Conditional Measure to calculate values based on Year in Matrix

[Anonymous]

Hi Everyone,

I have a excel file in that client has used one formula to calucalte the amount from 2015 to till 2021 Q2 but from 2021 Q3 they have used different formula to get amount.

I wrote  a measure to calculate the amount for 2015 to 2021 in matrix, Its working perfectly till 2021 Q2 but here i have to specify the condition it should use different measure to calculate the amount from 2021 Q3.

I need to write a measure to find amount from 2015 to 2021 Q2 & from 2021 Q3 onwards it should use different formula to caluclate the amount.

kindly help me out from this scenario.

[Anonymous]

Hi @Anonymous 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regard

Community Support Team _ Ailsa Tao

[amitchandak]

@Anonymous , My advice would be to have combine using filter

Assume you have date table and Q3 end on  2021-09-30

Assume you have two measures

m1 =[Measure]

m2= [Measure after Q3]

final measure

calculate([M1], filter('Date', 'Date'[Date]<= Date(2021,09,30) )) +

calculate([M2], filter('Date', 'Date'[Date]>  Date(2021,09,30) ))