Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 intelligence function showing the change from last month, which returns a number for each row.
What I want is for the second column (change from previous month) to only return a value when there is a value present in the first column, (Otherwise return blank). What is partly tripping me up is that the previous month function needs access to 'old' data, so I cannot just filter to current conditions as these conditions will not be accurate to last month also.
Solved! Go to Solution.
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)
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, thanks for taking the time to respond, much appreciated. Worked a treat
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |