Forum Discussion
Solved
Maintain date hierachy with date table
Hi, I have a data set "revenue" with revenue and date (only month end date involved but it's still down to day level). To use datesadd and tablesytd function I created a date table "Calendar" with ...
I solved my problem with reference to following links
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
https://sqldusty.com/2015/09/01/10-dax-calculations-for-your-tabular-or-power-pivot-model-part-1/
Hi,
The relatioship from revenue[date] to calendar[date] should be a many to one relationship. In the visual, drag Date from the Calendar Table.
To conclude, my current problems when using respective columns in the x axis of column charts:
1. Revenue[date]: no date hierachy in the chart (i.e top left drill down button in chart widget)
2. Calendar[date]: ytd prior year measures show blank value
3. Year-month-day hierachy from calendar[date]: ytd prior year measures show blank value, and column in x axis arranged as 2018 1, 2018 2, 2018 3, 2017 1, 2017 2....2017 12
Any advice? Thanks a lot
Kenny
1. Revenue[date]: no date hierachy in the chart (i.e top left drill down button in chart widget)
2. Calendar[date]: ytd prior year measures show blank value
3. Year-month-day hierachy from calendar[date]: ytd prior year measures show blank value, and column in x axis arranged as 2018 1, 2018 2, 2018 3, 2017 1, 2017 2....2017 12
Any advice? Thanks a lot
Kenny
I solved my problem with reference to following links
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
https://sqldusty.com/2015/09/01/10-dax-calculations-for-your-tabular-or-power-pivot-model-part-1/