Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This is my current matrix table. The info within is confidential, so I need to blur, but needed to show what I'm trying to accomplish.
Rows: Facility
Columns: Week Ending Date
Values: Potential Savings
I'm going to explain this in a couple different ways to make sure I'm getting across what is in my head. lol.
I'm wanting to add one more column at the end. With icons to show up or down arrows, indicating whether or not the number went up or down. Only between the last two values.
Another way of saying it: I need 5 weeks to show, but I want a 6th column at the end that compares the 5th week to the 4th week, and displays an arrow up or down depending.
Is this even possible?
Solved! Go to Solution.
Hi @FECStevenL ,
Please have a try.
Create a measure.
Trend Indicator =
VAR CurrentWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date]))
VAR PreviousWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date]) - 7)
RETURN
IF(CurrentWeekValue > PreviousWeekValue, "Up", IF(CurrentWeekValue < PreviousWeekValue, "Down", "Same"))
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @FECStevenL ,
Please have a try.
Create a measure.
Trend Indicator =
VAR CurrentWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date]))
VAR PreviousWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date]) - 7)
RETURN
IF(CurrentWeekValue > PreviousWeekValue, "Up", IF(CurrentWeekValue < PreviousWeekValue, "Down", "Same"))
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.