Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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)
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |