Forum Discussion

Infidti's avatar
Infidti
Frequent Visitor
2 years ago

DAX help

What I am looking to do is when the slicer for date is selected my calculation looks at dates leading up to it including it to work out the QTR up to that date. The following calculation doesn't work;

 

LastQuarter_PCT = 

CALCULATE(

    AVERAGE(YourTable[YourValueColumn]), 

    FILTER(

        ALL(YourTable[Date]), 

        YourTable[Date] = MAX(YourTable[Date]) &&

        YourTable[Date] >= STARTOFQUARTER(MAX(YourTable[Date]), 0) &&

        YourTable[EndDate] < STARTOFQUARTER(MAX(YourTable[Date]), 1)

    )

)

 

Any advice be great.

Need Help

1 Reply

  • Tahreem24's avatar
    Tahreem24
    Super User
    2 years ago

    Infidti It would be great if you could share the sample input data (not the real data) along with expected output.