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.

otravers's avatar
otravers
Community Champion
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.