Forum Discussion

gazz9ar's avatar
gazz9ar
Frequent Visitor
6 years ago
Solved

Measure with multiple dates

Hi again guys, im just getting crazy since i cant solve this problem at work.   I created a report so you can see how it should work First, the fact table: NOTE: Date 2 >= Date 1  ALWAYS! Ca...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    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

gazz9ar's avatar
gazz9ar
Frequent Visitor
6 years ago

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.

 

 

MFelix's avatar
MFelix
Super User
6 years ago

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