Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculations using XX days / weeks ago

Hi Community,    I know Ibend will know this and I'm sure many of you will as well. I could use some help on calculating a value XX days / weeks ago to finalize a calculation   I have tried: Th...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

    Based on your description, you should use the date in calendar table.

    You can try the following.

    Sum_preperiod =
CALCULATE (
    SUM ( 'Histo - Reformatted'[Non Promotion Thresholds Unit Volume] ),
    DATEADD ( 'Calendar'[Date], -180, DAY )
)

    Best Regards!

    Yolo Zhu

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you Yolo for your continued help. That was the formula I used originally. I guess it must be something in my calendar that is causing the issue. It may be something I just do in Excel vs. Power BI. I just prefer Power BI. 🙂