Forum Discussion
Dax formula error
Hi experts I have the following DAX formula.....which do not work with certain visuals...but work with others. i am trying to work out the previous 12 months based on a selected year and month fi...
I deleted your private message without downloading
Cheers,
Tom
Can you confirm receipt. Also from the table that does not have sales date you'll need to create a month and year column to that data set. Or the sales table data set. Also as I was in a rush to create a sample file did not have time to label tables correctly- sorry.
The measure needs to calculate the sum of sales 12 months back from the selected date correct? Based on two slicers year and month..dynamically