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.
Hello , please i need some help is there any way to calculate the number of days of an YTD ??
Thank you
Solved! Go to Solution.
Hello,
there are two ways I can tell you by now.
Adapting @Greg_Deckler you can make the year dynamic.
Measure = DATEDIFF(DATE(YEAR(TODAY(),1,1),TODAY(),DAY)
If you have a DateTable, which is many cases highly recommended you could use
Measure = COUNTROWS(DATESYTD(DateTable))
Something like:
Measure = DATEDIFF(DATE(2018,1,1),TODAY(),DAY)
thank you for your response , but is there another way to make it dinamically , means that it take the date automatically exemple if we were in 201 , i habe to change (2018,1,1) b myself to (2019,1,1) and i want it to be dynamic ( not static)
Hello,
there are two ways I can tell you by now.
Adapting @Greg_Deckler you can make the year dynamic.
Measure = DATEDIFF(DATE(YEAR(TODAY(),1,1),TODAY(),DAY)
If you have a DateTable, which is many cases highly recommended you could use
Measure = COUNTROWS(DATESYTD(DateTable))
simply awesome..saved my day 🙂
Hi .. wondering if you can advise .. I keep getting an error when using this function:
Measure = DATEDIFF(DATE(YEAR(TODAY(),1,1),TODAY(),DAY)
Too many arguments were passed to the YEAR function. The maximum argument count for the function is one.
Hi,
Try this
Measure = DATEDIFF(DATE(YEAR(TODAY()),1,1),TODAY(),DAY)
@asmagh,
Create new a new table using DAX below.
Date = CALENDAR("2018/1/1","2019/12/31")
Create measure using DAX below.
Measure = IF(MAX('Date'[Date])<=TODAY(),DATEDIFF(MAX('Date'[Date]),TODAY(),DAY),DATEDIFF(TODAY(),MAX('Date'[Date]),DAY))
Use slicer to filter your measure.
Regards,
Lydia
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |