Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Different Values between Published Report and Desktop report for YTD

Dear Power BI Community,   I have created a dashboard that provides a view over this month's figures and YTD figures. In Desktop version all values add up as they should. After publishing the repor...
Need Help
  • otravers's avatar
    otravers
    4 years ago

    It looks like you're trying to do time intelligence against the date column of the A-4(PL) fact table, which is generally speaking a bad idea. You need to have a date dimension (aka calendar table) where you'll define the end of fiscal year which will let you use time intelligence functions without hardcoding a specific date in them.

     

    You can use either Power Query or DAX to generate your date dimension, google with return a bunch of blog posts and videos.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you lots for your reply, It crossed my mind that maybe I should use a calendar table. However for the time being I just managed to fix the issue by using a filter in totalytd formula instead of the YearEndDate that is hardcoded. In the future I will listen to your advice and use a Calendar Table.

 

Many thanks again