Forum Discussion
Creating date range in measure
Hi guys,
i created a measure that should give me the revenue for the last 90 days rolling:
It works fine as long as i just show the measure in a card with the correct last 90 day revenue of 14K.
But once i pull the measure into the bar chart all bars for every month show the value of the last 90 days:
In the bar chart it should should show the distribution of the revenue of last 90 days but not always the same revenue.
Anybody an idea why that is and how to fix that?
Thank you!
2 Replies
Hi Anonymous
it because of lastDateAvailable variable
you use ALL() sentence that remove all filters and return to you always the same value
try
lastDateAvailable = MAX('Bestselling'[dBezhalt])Anonymous , Try rolling like this
example
Rolling 30 day = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD(Date[Date],MAX(Sales[Sales Date]),-30,Day))
Use Date Table
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
