Forum Discussion
PowerBI Date table help
I have imported 2 dimension tables. I have created a date table using formula
Dim_Date = CALENDARAUTO()
I have disabled auto date in PowerBi desktop.
I have created a measure for total items from table 1
I have department name in table 2.
I am looking to get a break down of count of items by department over time using date field in date table. It looks fine when I add count of items and departments. But not when I add months in year breakdown. Nothing displays as far as date.
If I delete the relationship between date table and other table, data displays but is not relative to the time period. The entire year simply has same result.
I will appreciate any guidance.
2 Replies
Anonymous Did you have created a relationship of this new calendar table with the table1?
