Forum Discussion
Solved
Facing issue with DATEADD function
Hi all, I am a beginnering and try to flow previous year cost using DATEADD function. But, I am not getting the desired results. I am sharing the screenshot of the result that I am getting. Pleas...
Hi,
Try this approach
- Create a Calendar table with calculated column formulas for Year, Month name and month number
- Create a relationship (Many to One and Single) from the Date column of the Fact table to the Date column of the Calendar table
- To your visual/filter/slicer, dray Year/Month name from the Calendar table
- Write this measure
Measure = calculate([Cost of logistics],previousmonth(calendar[date]))
Hi devaverma
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.