Forum Discussion
Want to Show measures dynamically with time
AshDil , First of all unpivot the budget table (month)
https://radacad.com/pivot-and-unpivot-with-power-bi
Now with help from mon the and year create date , a new column
date = "01-" & [Month] & "-" [Year] // change data type to year
Join all three tables with date table having qtr year etc
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Create a common category table and use that too
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
then analyze with help from date and category table
- AshDil5 years ago
Helper V
Hi amitchandak ,
I have done above all steps but my requirement is to show measures dynamically with time. Please help me on that.
Thanks,
AshDil.