tableau-error-cannot-mix-aggregate-non-aggregate

[Akriti Lal]

For my use case Create calculated fields to show the value of 1stLast Month ,  If I try to create the Formula it would be difference between the Current Month and the Maximum Month that we have When using Calculated Field — Error drop down shows – “Cannot Mix Aggregate and Non Aggregate

[Akriti Lal]

We get this error because we are trying to do calculation at Different Level of Details. In order to fix this
“Cannot Mix Aggregate and Non Aggregate “ , we will have to use the LOD function. LOD is a very important & interesting topic and you can visit my LOD Knowledge Material to Understand it more , but as a quick fix for this error , what you need to do is put the
aggregate function inside curly braces i.e. the Max() function that we use should be inside the curly braces . Read the https://www.technicaljockey.com/tableau-training-consultant/tableau-error-cannot-mix-aggregate-non-aggregate/

[Author]

Posts