Forum Discussion

Frequent Visitor

5 years ago

Solved

Multiple Dates

Hi I'm really stuck and hoping you can help. My module contains A fact table for TASKS, containing multiple date fields, CREATED DATE, DUE DATE, COMPLETED DATE A date table with an active re...

Need Help

jdbuchanan71
5 years ago
Hello DonBisset

It is a pretty common problem. Take a look at this post that discusses how to handle it.
https://blog.enterprisedna.co/working-with-multiple-dates-in-power-bi/

aj1973

Community Champion

5 years ago

Hi DonBisset

To your Model add 2 other inactive relationship between Due date and Completed date to the Calaendar table.

Then add 2 measures using Dax formula USERELATIONSHIP to get the sum for due and completed tasks

Forum Discussion

Multiple Dates

Related content

Multiple Date Fields

Date Relationships - Multiple Tables, Multiple dates.

Fact Table Multiple Dates Relationship with Dimension Date

Date difference with multiple criteria

Handling multiple dates with one date picker in semantic model