Forum Discussion
DAX formula issue
I have 5 DAX conditions and an IF condtion to return the measure result. The IF comparison condition is returning the result of only the month selected in Month slicer instead of returing last 3 mont...
The variable orders_3M in IF condition- if(((Orders_1>=Orders_2)&&(Orders_2>=Orders_3)&&(Orders_3>=Orders_4)),orders_3M, BLANK()) is not returning last 3 months data based on month slicer selection.
For ex- For month selection Apr, it returns data of Feb and Apr instead of Feb, Mar, Apr.
(Orders_1>=Orders_2)&&(Orders_2>=Orders_3)&&(Orders_3>=Orders_4) condition holds TRUE.
I am using this measure in a Column chart with Values as the 'measure name' and Axis as 'month'.
to be honest its hard to see whats going on without having some data to look at, have you checked each measure to see what its returning?