Forum Discussion

Voose's avatar
Voose
Helper III
9 years ago
Solved

Using Waterfall Charts

After watching the learning videos and resources around waterfall charts I realised that in the video (https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-8-create-waterfall-funnel...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Voose,

     

    As most time intelligence functions(DAX) require an individual and continuous Calendar table to work correctly, you may need to create an individual Calendar table if you don't have yet(you can use CALENDAR function to create it).

     

    Then you should be able to create a relationship between your "Opportunity" table and the Calendar table with the date column, and use the date column from the Calendar table in SAMEPERIODLASTYEAR function of the "LY Total Sales" measure.:smileyhappy:

    LY Total Sales = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( Calendar[Date] ) )

     

    Regards