topic Re: DAX Command in DAX Commands and Tips

DAX Command

milmendez — Wed, 09 Aug 2023 21:02:09 GMT

I have a table that include Created date and Topic columns. I need to add a formula in a new Due date column where PBI will take that Created date (formatted as 8/4/2023), and add 2 days (excluding weekends) but only when the Topic equals TeamConnect>Performance/Slow/Freezing. If Topic is anything other than that, then Due Date should be 1 day (excluding weekends). The Due date should display as a date.

Ex. Created date is Friday 8/4/2023 and the Topic is TeamConnect>Performance/Slow/Freezing, then Due date displays 8/7/2023 but if Topic is Reports>Add New, then due date displays 8/8/2023.

I tried creating it as a conditional column, but was stuck at the output value since I wasn't sure how to code it to display as a date.

I think i need to use a logical function, but i'm not sure if i need additional columns first or i can do everyting within the DAX command or column formula. I'm new to PBI and got assigned a tough one. Any help would be greatly appreciated. Thanks.

Re: DAX Command

johnt75 — Thu, 10 Aug 2023 08:48:22 GMT

Have a look at https://www.youtube.com/watch?v=2HkBbqxBzF0 from SQLBI.

Re: DAX Command

barritown — Thu, 10 Aug 2023 09:35:49 GMT

Hi milmendez,

You could try a calculated column like this:

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

Re: DAX Command

milmendez — Thu, 10 Aug 2023 15:46:08 GMT

Thank you so much. I was able to get that formula to work exactly how I needed it to. Awesome!

I do have another question. I have three other Topics that would follow the same rule. How can I add additional Topics to the fomula.

VAR MainAddendum = IF ( 'Help Requests'[Topic] = "TeamConnect>Performance/Slow/Freezing", 2, 1)

Re: DAX Command

barritown — Thu, 10 Aug 2023 15:51:25 GMT

Like that:

VAR MainAddendum = IF ( 'Help Requests'[Topic] IN { "TeamConnect>Performance/Slow/Freezing", "Topic 2", "Topic 3" }, 2, 1)

Re: DAX Command

milmendez — Thu, 10 Aug 2023 16:41:10 GMT

Thank you. This was very helpful as well.