Forum Discussion

milmendez's avatar
milmendez
New Member
3 years ago
Solved

DAX Command

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 ...
  • milmendez's avatar
    milmendez
    3 years ago

    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)
milmendez's avatar
milmendez
New Member
3 years ago

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)
  • barritown's avatar
    barritown
    Solution Sage
    3 years ago

    Like that:

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