Forum Discussion
How to Create Days Left?
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
Hi Anonymous
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.
3 Replies
Anonymous ,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)
Anonymous use the DATEDIFF DAX to get the result. Refer the below screenshot.
Hi Anonymous
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.
