Forum Discussion
Measure with multiple dates
Hi gazz9ar ,
Why don't you just create the Range of Days column on the Fact table instead of the calendar table?
Make a relationship between Date1 and Calendar table
In order to simplify you can create it on the query instead of the DAX so it will refresh faster.
Check PBIX file attach.
Regards,
MFelix
Hi gazz9ar ,
Sorry but I'm not understading the request, you want to select a period based on what column? The filter of the period will filter what information?
Or do you want to have one visual that is impacted by the filter and other that is not?
Regards,
MFelix
It is simple, but i dont know if the visual can show it correctly.
First, you select a period based on Date 1 and you will get a list of records with Amounts and Date 2
Afterwards, i want to group by THOSE dates from Date 2 the sum of the amount.
Hi gazz9ar ,
Why don't you just create the Range of Days column on the Fact table instead of the calendar table?
Make a relationship between Date1 and Calendar table
In order to simplify you can create it on the query instead of the DAX so it will refresh faster.
Check PBIX file attach.
Regards,
MFelix