Calculate no. of days between 2 Project Status's Dates

[suneelkethagani]

Hi All,

I have the Columns 

Project ID    Project Status     Status1Date   Status2Date Status3Date

in my model.

I need to find out,

The Project "Project1" starts on January 1, 2022 with Status "Start" and

then changed it's status to "In Progress" on April 30, 2022. So the status "Start" involved in Q1 (90 Days) and Q2 (30 Days).

I want to show total 120 Days in Q2 for the status "Start". Can you please tell me the DAX code?

Visualization: Line and Clustered Column Chart

X-Axis: Quarter

Column Y-Axis: No. of Unique Projects

Line Y-Axis: Total No. of Days (i.e., 120 Days)

Thanks in advance.....

[daXtreme]

How to Get Your Question Answered Quickly - Microsoft Power BI Community