Get average from -90 day from the start date to end date based on slider.

[phyconia]

Hello I am pretty new to powerbi and i dont know what this code is doing but it doesnt seem to break anything. Is this looking for the average volume of cars between -90 days from the first selected date to last selected date ?

Car Inital =

IF(

    ISFILTERED('Calendar'[Date]),

    VAR __Firstdate = FIRSTDATE('Calendar'[Date])

VAR __Lastdate = LASTDATE('Calendar'[Date])

    RETURN

        AVERAGEX(DATESBETWEEN('Calendar'[Date],DATEADD(__Firstdate, -90, DAY),__Lastdate),

            CALCULATE(AVERAGEX(KEEPFILTERS(VALUES('Calendar'[Date])),CALCULATE(SUM('master_csv'[Car]))))

        )

)

[SpartaBI]

@phyconia check out this article: https://www.daxpatterns.com/standard-time-related-calculations/
Read it carefully and it will give you what you need and much more

      

Showcase Report – Contoso By SpartaBI

[phyconia]

Thank you I have already been through this article to no avail. thank you for your responce  🙂 

[amitchandak · Accepted solution]

@phyconia , Are you looking for something like this

Car Inital =
IF(
ISFILTERED('Calendar'[Date]),
VAR __Firstdate = FIRSTDATE('Calendar'[Date])
VAR __Lastdate = LASTDATE('Calendar'[Date])
RETURN
CALCULATE(AVERAGEX(VALUES('Calendar'[Date]),CALCULATE(SUM('master_csv'[Car]))) ,
DATESBETWEEN('Calendar'[Date],DATEADD(__Firstdate, -90, DAY),__Lastdate) )

[SpartaBI]

@phyconia ok, I'm not sure what you are trying to do. Can you share the file and hard code in a text box the result you want to get and the logic behind it.
P.S. will appreciate your kudos 🙂