topic Addcolumns with Condtions in DAX Commands and Tips

Addcolumns with Condtions

Chandrashekar — Thu, 06 Jan 2022 10:17:27 GMT

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

Re: Addcolumns with Condtions

ValtteriN — Thu, 06 Jan 2022 10:30:13 GMT

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?

Re: Addcolumns with Condtions

Chandrashekar — Thu, 06 Jan 2022 10:36:04 GMT

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

Re: Addcolumns with Condtions

ValtteriN — Thu, 06 Jan 2022 10:46:55 GMT

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!

Re: Addcolumns with Condtions

Chandrashekar — Thu, 06 Jan 2022 10:59:10 GMT

Hello Team,

am trying to get result in below format.

Regards,

Chandrashekar B

Re: Addcolumns with Condtions

ValtteriN — Thu, 06 Jan 2022 11:04:37 GMT

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)

Re: Addcolumns with Condtions

Chandrashekar — Thu, 06 Jan 2022 11:15:43 GMT

Hello Team,

Thanks for the solution.

Regards,

Chandrashekar B

Re: Addcolumns with Condtions

Chandrashekar — Fri, 07 Jan 2022 04:33:52 GMT

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")
)
)