Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Why does this script not work:
If(Interval(Now() - UpdateDT, 'm') >=10, '#FDA50F')
The values produced by Interval(Now() - UpdateDT, 'm') works fine but when i try to use it for conditional formatting it does not.
As i wanted to use this value repeatedly, I've tried to use Interval(Now() - UpdateDT, 'm') in a variable but i get no results at all, so i have to use the code in the measure itself for it to work.
I've tried using variables like this before but they never seem to work. What am i doing wrong on both counts?
Thanks in advanced..
I have solved it.
I had to use the NUM# function in the load script, thus:
NUM#(Interval(Now() - UpdateDT, 'm'), '0.0') as TaskDuration
Hi @cyberblitz
UpdateDT <-- might be contains many values. So it doesn't work in the variable / conditional format.
Might be, You can try like
If(Interval(Now() - Max(UpdateDT), 'm') >=10, '#FDA50F')
Thanks for your suggestion but it does not work.
I have resorted to including the script in the data load editor and yet it still does not work. I have even resorted to changing the column to a dimension from a measure and it still does not work.
Why does it not see the integer value?
I have solved it.
I had to use the NUM# function in the load script, thus:
NUM#(Interval(Now() - UpdateDT, 'm'), '0.0') as TaskDuration