▲ 2 r/PowerBI
Use two date filters on different columns in table
I'm tasked in creating a table where the users can change the year and quarter in one filter, and the first column will fetch the cost for that period. The second quarter + year filter will work the same but fetch the cost for that specific period.
Lastly we want to evaluate the difference between the columns and present the change in %
I have one table with nr, cost and date and a separate date table where year and quarter are mashed together.
I'm at a loss at how to solve this without duplicating the fact table.
u/talidass — 1 day ago