Forum Discussion

Frequent Visitor

2 years ago

Solved

Single Projected Value vs. Multiple Actual Spend

Hello, I'm trying to create a budget dashboard that has one clustered bar graph that will show: 1) Total spend vs. budgeted amount (year, quarter, month, day via drill down menu) I have t...

Need Help

Tips and Tricks

amitchandak
2 years ago
ProfessorEgg28 , Hope you have created a common date table, joined with date of both tables and using it

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

Anonymous

Not applicable

2 years ago

Hi ProfessorEgg28 ,

As amitchandak said, a separate date table needs to be created.

Create a one-to-many relationship between the date table and the two tables. Change the date columns in the date table to a hierarchy. Drill down can be done for this date.