Creating date range in measure

[Anonymous]

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!

[az38]

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])

[amitchandak]

@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/