Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a expression like this:
if
(Today()-[DAX Service Order Created Date] >1, 'TROUBLE!', 'All is Good! ')
I want to make the expression like:
If (Today()-[DAX Service Order Created Date] =3 then 'Showw Warning'
If its >3 then show 'Trouble'
And If its ❤️ then show 'All is Good'.
Can i have all these three logic in one if statement?
Thanks,
Ahmed
Try this
if (Today()-[DAX Service Order Created Date] = 3, 'Show Warning',
if (Today()-[DAX Service Order Created Date] >1, 'TROUBLE!', 'All is Good! '))
Hi Colin,
Anything greater than 1 is showing 'TROUBLE' but whaen its equl to 3 thenit should be showing 'Warning'
Thanks,
Ahmed
If(Today()-[DAX Service Order Created Date] >3, 'Trouble',
If(Today()-[DAX Service Order Created Date] =3, 'Warning',
'All Is Good'
)) as Expression
This should work
if (Today()-[DAX Service Order Created Date] = 3, 'Show Warning',
if (Today()-[DAX Service Order Created Date] >3, 'TROUBLE!', 'All is Good! '))
Hi,
Try like this
LOAD
*,
If(Today()-[DAX Service Order Created Date] =3, 'Warning',
If(Today()-[DAX Service Order Created Date] >3, 'Trouble',
If(Today()-[DAX Service Order Created Date] <3, 'All Is Good', 'Not Available'
))) as Category
Hope this helps you.
Regards,
Jagan.
Hi
Does [DAX Service Order Created Date] contain a time component? If so, then you will need something like
if (Today()-Floor([DAX Service Order Created Date]) = 3, 'Show Warning',
if (Today()-[DAX Service Order Created Date] >3, 'TROUBLE!', 'All is Good! '))
HTH
Jonathan