Forum Discussion
Conditional Measure to calculate values based on Year in Matrix
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.
2 Replies
- amitchandak
Super User
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) ))
