Forum Discussion
Solved
DateADD Function not returning dates correctly
My table appears to have contiguous dates. I am trying to compare the sum of charges from my current month as of a specific date to a prior month for the same time frame. For example, I want to com...
You must have a seperate date table for DATEADD to work correctly. If you are pulling your dates from your fact table you will encounter errors. All Time intelligence calculations require a seperate date dimension table.
See this link for more information:
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/