Forum Discussion

MagikJukas's avatar
MagikJukas
Resolver III
3 years ago
Solved

Measure includes all date

Hi, I am trying to build a rolling 28 days measure: CALCULATE (     SUM ( OrderEntry[Total] ),         FILTER(         ALLSELECTED(OrderEntry),             (OrderEntry[Created on])>MAX(OrderEnt...
  • MagikJukas's avatar
    MagikJukas
    3 years ago

    So, the only solution I found to fix it, is to create a new table containing all dates values.

    Then I use it in my chart. this solve the issue, but I am still persuaded it can be solved my reworking the measure.
    Hopefully someone will figure this out.

     

    OrderEntry Calendar = VALUES(OrderEntry[Date2])
MagikJukas's avatar
MagikJukas
Resolver III
3 years ago

So, the only solution I found to fix it, is to create a new table containing all dates values.

Then I use it in my chart. this solve the issue, but I am still persuaded it can be solved my reworking the measure.
Hopefully someone will figure this out.

 

OrderEntry Calendar = VALUES(OrderEntry[Date2])