How to Create Days Left?

[TapZxK]

Hi Guys, 

I have done this in Excel but am strugling to recreate in Power BI. 

I have a dedicated Calendar table with [Dates] Column.

I have a Scheduling Manager table that contains [Scheduled Start Date] Column.

I have established a One to Many relationship between these tables. 

I'm trying to represent how many days have left or passed since the last asignment date of a team member relative to todays date. 

Excel Screenshot attached for visual representation:

I would greatly appreciate Your help.

BR,

Kris

[v-xiaotang · Accepted solution]

Hi @TapZxK 

if you want to solve it by using measure, you can take steps below for reference.

First, create a measure

available in =

DATEDIFF ( TODAY (), MIN ( 'Table'[available as of] ), DAY )

Then, you will get the following

Is this the result you want? Hope this is useful to you.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@TapZxK use the DATEDIFF DAX to get the result. Refer the below screenshot. 

[amitchandak]

@TapZxK ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

usually

datediff([Scheduled Start Date] , today(), day)