topic Filter table by column then on filter value increase date by 14 days all in 1 new column in DAX Commands and Tips

Filter table by column then on filter value increase date by 14 days all in 1 new column

bzafft123 — Thu, 09 Mar 2023 18:21:07 GMT

Hello,

I have a table with the following columns Profit Center, Requested Date, and Target Delivery Date. I'm looking for the Target Delivery Date to be updated by i.e. 14 days if Profit Center is Preschool or if Profit Center is Schools 30 days. I want these updates all in one new column.

Example: Preschool(Profit Center) | 1/7/2020 (requested Date) | "new column" = 1/21/2020 (14 days added)

Please let me know if you need additional information.

Re: Filter table by column then on filter value increase date by 14 days all in 1 new column

FreemanZ — Thu, 09 Mar 2023 18:29:39 GMT

hi bzafft123

could provide the value of your expected new column directly? It would be easier for all.

Re: Filter table by column then on filter value increase date by 14 days all in 1 new column

bzafft123 — Thu, 09 Mar 2023 18:33:11 GMT

FreemanZ Its in my example: Example: Preschool(Profit Center) | 1/7/2020 (requested Date) | "new column" = 1/21/2020 (14 days added

Preschool = add 14 days

Studios = add 30 days

etc.

Re: Filter table by column then on filter value increase date by 14 days all in 1 new column

FreemanZ — Thu, 09 Mar 2023 18:38:11 GMT

hi bzafft123

try like:

new column =

SWITCH(

[Profit Center],

"Preschool", [Requested Date]+14,

[Requested Date]+30

)

Re: Filter table by column then on filter value increase date by 14 days all in 1 new column

bzafft123 — Thu, 09 Mar 2023 18:43:08 GMT

That worked! Thank you so much!