Forum Discussion
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...
I may be miss understanding but can you not just add a date filter?
How? I tried to use the next measure:
Real + fcst = CALCULATE([SUMA OIL REAL(BLS)] + [FCST OIL],Consolidado[VOLUME_DATE] >= [FechaCorte])
([FechaCorte] is the date from which I want the measurements to start adding up)
But the measurement gives me an error
So it looks like its pulling in a list of dates try using the ISONORAFTER function:
ISONORAFTER function (DAX) - DAX | Microsoft LearnIf you can help me with the measure I would aprecciate it 🙂 I don't know how to use it in this case