Forum Discussion
Chandrashekar
Resolver III
Resolver IIIAddcolumns with Condtions
Hello Team, am new to Power Bi. Can you guide how to addcolumns when condition met(Example below) In below example if day is Thursday then I need to addcolumns. date period = var todayday...
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!
ChandrashekarResolver III
Resolver IIIHello,
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
ValtteriN
Community Champion
Community ChampionI 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!