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
Tahreem24's avatar
Tahreem24
Super User
2 years ago

CarlosOlmos29 You can use the below measure to achieve your result, in my case I took the date after 2-Jan-2024, likewise you can write your expected date value.

Measure = CALCULATE(SUM('Table'[Value1])+SUM('Table'[Value2]),FILTER('Table','Table'[Date]>DATE(2024,1,2)))

 

 

 

  • CarlosOlmos29's avatar
    CarlosOlmos29
    Helper I
    2 years ago

    It worked with the date, but it is not adding up the measurements. It looks like the screenshot below.

     

    This is the measure I am using:

    Real + fcst = CALCULATE([SUMA OIL REAL(BLS)] + [FCST OIL],FILTER(Consolidado, Consolidado[VOLUME_DATE] > MAX(Real[VOLUME_DATE])))
    I think it is not adding up because the SUMA OIL REAL(BLS) data is being repeated after March 15. Actually there is no more data entered after that date. We could modify the measurement so that the last data of March 15 of SUMA OIL REAL is added with the one of April 15 of FCST OIL.