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.
Going round in circles trying to create a measure that subtracts a static date from today's date (dynamic) to give a running count of elapsed days. I would have thought this very simple, but too complex for me!
It seems
ElapsedDays = DATEDIFF((DATE(2020,02,15)),TODAY(), DAY)
and
ElapsedDays = TODAY()-DATE(2020,02,15)
don't work
Solved! Go to Solution.
@CJDK , This formula seems correct
ElapsedDays = DATEDIFF(DATE(2020,02,15),TODAY(), DAY)
what is the problem you are facing on this, When I checked it gives a number 478 , which seem fine
Thanks Amitchandak - exactly what I needed 👍
@CJDK , This formula seems correct
ElapsedDays = DATEDIFF(DATE(2020,02,15),TODAY(), DAY)
what is the problem you are facing on this, When I checked it gives a number 478 , which seem fine
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 |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |