Current date report and check other dates report

[askspepsi]

Greeting Guys,

I have the below report in which i want the report to show the current dated report after the scheduled refresh everyday (Which i Have kept in the online service), but if i wanted to change the date to see other dates report is it possible.

[Anonymous · Accepted solution]

Hi @askspepsi ,

Refer this mothed.

Create a calendar table as slicer.

Create a measure like below and add it to visual filter where measure =1.

If the slicer is selected, show selected date's data, if the slicer is not selected, show today's data.

measure = IF(ISFILTERED('table'[date]),IF(SELECTEDVALUE('table'[date]) in VALUES('calendar'[date]),1,0),IF(SELECTEDVALUE('table'[date])=today(),1,0))

Best Regards,

Jay

[amitchandak]

@askspepsi , You need to create a column like this in your date table and sort it on date. Save on today

Is Today = if("Date"[Date]=TODAY(),"Today",[Date]&"")

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35