Forum Discussion
Addcolumns with Condtions
I see, in cases like these you can create a filter measure and use that to filter your slicer.
Example:Last 3 days slicer = IF(max('Calendar example'[Date])>=TODAY()-3 && max('Calendar example'[Date])<=TODAY(),1,0)
End result in slicer:
I hope this helps to solve your issue and if it does consider accepting this as a solution and gicing the post a thumbs up!
Hi,
Could you specify a bit more what you are trying to accomplish? ADDCOLUMNS creates a new table which has columns from your original table and then new columns e.g. SUMX columns. Where and why do you want to add this data in question?
Hello,
am trying to add last 3 days in Slicer. If it is Monday slicer should display last 3 days for ex:
Day=today(10-Jan-2022 Monday) then slicer should display below dates
1. 29-Dec-2021 Wed
2. 30-Dec-2021 Thu
3. 31-Dec-2021 Fri
Regards,
Chandrashekar B
I see, in cases like these you can create a filter measure and use that to filter your slicer.
Example:Last 3 days slicer = IF(max('Calendar example'[Date])>=TODAY()-3 && max('Calendar example'[Date])<=TODAY(),1,0)
End result in slicer:
I hope this helps to solve your issue and if it does consider accepting this as a solution and gicing the post a thumbs up!Hello Team,
am trying to get result in below format.
Regards,
Chandrashekar B
Hi,
You can change the slicer in my example to a list and then make its alignment horizontal:
Also to exclude today from the slicer you can modify the dax a bit:
Last 3 days slicer = IF(max('Calendar example'[Date])>TODAY()-3 && max('Calendar example'[Date])<=TODAY(),1,0)