Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (11.1k points)

I was trying to create a report, which shows the data

I am using DAX filter

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

How can I do this? 

1 Answer

0 votes
by (22.5k points)

Set a slider by using this formula

SlicerDate = SELECTCOLUMNS('Date', "Date",[Date])

And then make small changes in DAX

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")) 

And the do the following

enter image description here 

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

Related questions

0 votes
1 answer
asked Nov 22, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Nov 4, 2020 in BI by Sudhir_1997 (55.5k points)
0 votes
1 answer
asked Dec 1, 2020 in BI by Chris (11.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...