Show the start date of a specific project

[Berl21]

Hi,

I am working on a report where two different projects started with a few days intervals. For the second one, I would like to specify the start date as a measure shown in a card, and then calculate the number of days between this date and today.

I know it is possible to define a specific date as a measure, but I can't find out how 😕 😕 😕

Any help for that would be much appreciated.

Thanks!

Pauline.

[Adescrit · Accepted solution]

Hi @Berl21 

If the date you want to use as the "Start Date" exists within your dataset for project 2, you could use the MIN() function to return the minimum date in a column and treat that as the start date.

Howev er if you want to hard-code a date using DAX you can use the DATE function. For example today's date using this hard-coded method would look like this:

Start Date = DATE( 2022, 08, 22 )
// DATE( yyyy, mm, dd)