Forum Discussion
Date functions in Power Bi
Hi all, I'm trying to make the exact calculations below in Power BI, and while they work flawlessly in Excel, I'm having trouble getting them to function in Power Bi. Could someone please assist ...
so, what should I use instead of today()?
ChiragGarg2512
Solution Sage
Solution Sagein case of
2- use day(today()) to get the day date. for ex, day(17/04/2024) gives 17.
3- use int(Today()-startdate), this should give the day difference between two dates
Today() provides the current date, it is up to the user to extract the date, day, month, quarter, and year from it.