topic Re: How can I have an industry standard date parameter in Power BI? in DAX Commands and Tips

How can I have an industry standard date parameter in Power BI?

mlane — Wed, 13 Nov 2024 23:35:47 GMT

I am try to create a date parameter like can in Qlik Sense, Rshiny, Tableau with the following properties:

Its a true date parameter that treats date as a series instead of a list. It can have a default date. It can have a min and max range.
It able have a ""dynamic"" default value set by a calculation from a field. In my most recent case, I would want that field to the refresh date that the data and semantic model was last refreshed
Is fixed at load or refresh

P.S. This is kind of a industry standard concept in Business Intellegence at this point.

FreemanZ — Thu, 14 Nov 2024 00:12:35 GMT

in your date table definition, you can reference today() or MIN/MAX of a date column in your fact table, like:

Date =

ADDCOLUMNS (

CALENDAR (MIN(Fact[Date]), TODAY()),

"Year", YEAR ( [Date] ),

"Qtr", "Q" & FORMAT ( [Date], "Q" ),

"MonthNO", FORMAT ( [Date], "MM" ),

"Month", FORMAT ( [Date], "MMM" ),

"Day",FORMAT ( [Date], "DD" ),

"YYQ", FORMAT ( [Date], "YY" ) & "Q" & FORMAT ( [Date], "Q" ),

"YY/MM", FORMAT ( [Date], "YY/MM" ),

"Weekday", WEEKDAY ( [Date],2 )

)