0 votes
1 view
in BI by (1.7k points)
recategorized ago by

How can we set up a report which shows the default of today's date

I tried to create a report filter in DAX

Date_Today_Default = 
var currentrowdate = FORMAT('Date'[DATE], "dd/mm/yyyy")
var DateToday = FORMAT(TODAY(),"dd/mm/yyyy")
return
IF(DateToday = currentrowdate, "YES", "NO")

But I want to default values when a report is open

1 Answer

0 votes
by (2.6k points)
edited by

Make some changes and try with this formula

Date_Today_Default = 
var currentrowdate = FORMAT(Max('Date'[Date]), "dd/mm/yyyy")
var DateToday = FORMAT(TODAY(),"dd/mm/yyyy")
return
IF (isFiltered(SlicerDate[Date]), "YES", IF (DateToday = currentrowdate, "YES", "NO"))

If you want to learn more about Power BI, then read Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.

Related questions

0 votes
1 answer
asked 1 day ago in BI by Chris (1.7k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 4 in BI by Sudhir_1997 (46.8k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...