Forum Discussion

jbird258's avatar
jbird258
Frequent Visitor
3 years ago
Solved

How to filter a Time Intelligence Function

My issue is, I have a matrix visual with two columns. The first column is a simple sum that returns either a number or a blank depending on the slicer settings.  The second column is a time int...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi jbird258 try to add a IF condition in your last step of change from previous month, like

     

     

    change from previous month =

    ....

    VAR _value =

    ...

    RETURN

    IF([Amber Count]=BLANK(), BLANK(), _value)

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi jbird258 try to add a IF condition in your last step of change from previous month, like

 

 

change from previous month =

....

VAR _value =

...

RETURN

IF([Amber Count]=BLANK(), BLANK(), _value)

jbird258's avatar
jbird258
Frequent Visitor
3 years ago

FreemanZ, thanks for taking the time to respond, much appreciated. Worked a treat