Addcolumns with Condtions

[Chandrashekar]

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=format(today(),"ddd")="Thu"

return

var columnadd=

ADDCOLUMNS(

     DATESINPERIOD('date'[Date_rec],TODAY()-3,1,DAY),

     "Type", "Day3"

)

return

Regards,

Chandrashekar B

[ValtteriN]

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?

[Chandrashekar]

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

[ValtteriN · Accepted solution]

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!

[Chandrashekar]

Hello Team,

am trying to get result in below format.

Regards,

Chandrashekar B

[ValtteriN]

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)

[Chandrashekar]

Hello Team,

Thanks for the solution.

Regards,

Chandrashekar B

[Chandrashekar]

Hello Team,

Can you please advise if still I can use if condition to acheive task.

My intention to explore more. Example below:

date period =
todayday=format(today(),"ddd"="Mon"

if(todayday,
ADDCOLUMNS(
DATESINPERIOD('date'[Date_rec],TODAY()-3,1,DAY),
"type",format(DATESINPERIOD('date'[Date_rec],TODAY()-3,1,DAY),"dd-mmm")
)
)