Forum Discussion
MickeLearnPBI
Helper I
2 years agoProblem with Switch and more than... Any ideas?
I have tried to do a dax with switch but does not seem to be working with value under och over. Anyone have any ideas to do it better? [Status] = SWITCH( TRUE(), 'table'[InvestigationID] =...
- Anonymous2 years ago
Thanks for the reply from Jihwan_Kim , please allow me to provide another insight:
Hi MickeLearnPBI ,
Based on your description, the calculated column created, refer to the following:
Status = SWITCH( TRUE(), Notifications[InvestigationID] = 0 && Notifications[DecisionID] > 0, "Notification One - investigation not opened", Notifications[DecisionID] > 0, "Notification two - Decision not to open investigation", Notifications[InvestigationID] > 0, "Actualizations processed", Notifications[InvestigationID] = 0, "New actualizations", "Closed actualizations" )Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
2 years agoNot applicable
Thanks for the reply from Jihwan_Kim , please allow me to provide another insight:
Hi MickeLearnPBI ,
Based on your description, the calculated column created, refer to the following:
Status =
SWITCH(
TRUE(),
Notifications[InvestigationID] = 0 && Notifications[DecisionID] > 0, "Notification One - investigation not opened",
Notifications[DecisionID] > 0, "Notification two - Decision not to open investigation",
Notifications[InvestigationID] > 0, "Actualizations processed",
Notifications[InvestigationID] = 0, "New actualizations",
"Closed actualizations"
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MickeLearnPBI
Helper I
2 years agoThanks! That worked like a charm 👍