Thanks for this solution, you have solved my problem.
Next requirement is when this table is shown , my client would like to interact with a slicer that contain, the date of today, date of yesterday and other day? See the image below.
You just need a function to calculate it based on your date. My date field is called sql_date just replace your date.
Selector = if(Query1[sql_date]=date(year(now()),month(now()),day(now())),"Today",if(Query1[sql_date]=date(year(today()-1),month(today()-1),day(today()-1)),"Yesterday","Other"))
View solution in original post
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!