Forum Discussion

CarlosOlmos29's avatar
CarlosOlmos29
Helper I
2 years ago

Add two measures after a date

Hello Power BI Community. I am trying to sum two DAX measures, but I need them to be summed only after a certain date (after the line in the image). I tried with an if but it didn't work. I would ap...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi CarlosOlmos29 ,

I create a table and two measures as you mentioned.

Then I create a measure and here is the DAX code.

 

Measure = 
CALCULATE (
    'Table'[Measure1] + 'Table'[Measure2],
    FILTER ( 'Table', 'Table'[Date] > DATE ( 2024, 1, 2 ) )
)

 

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.