Wednesday, August 26, 2020

Power BI - How to Set a Default Slicer Value (8:49)

 https://www.youtube.com/watch?v=pCgK-Ze3nhA


Date example - add a DateRange calculated column with this DAX:


DateRange = IF(MONTH(Date[Date]) = MONTH(TODAY()) && YEAR(Date[Date]) = YEAR(TODAY()), "Current Month", MONTH(TODAY()) - MONTH(Date[Date]) & " Months ago")


No comments:

Post a Comment