calculate sales in the current month - N
hello i want to create a measurethat calculate sales in the current month -2 so for example if we are now in february i want to clalculate values in december(between 1-12-2020 and 31-12-2020) and so on for current month-3 i want to get the values for november (between 1-11-2020 and 30-11-2020) i would like this to be calculated dynamically so every time curremt month changes it will shift the number of months in the measurere automatically thank you,
How to display last N months data?
Hi, I am trying to display last 6 months data using a new Measure of a seleted Date. However, it returns with cummulative result of the last 6 months instead of showing last 6 months' data. Appreciate if anyone can help? Measure = CALCULATE(calculate(count(Tracker[ID]), DATESINPERIOD(DIMDate[Date],max(DIMDate[Date]),-6,Month))) Data: Result (If I select 2020-12, table below showing 3 which is cumulative data from Jul'20 to Dec'20) Date Slicer (From Date Table): I've two simple tables: Thanks!
