Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
I want to show case data in the below format and also i want to arrive max of selected months.
CAFÉ | ITEM 1 | Jan Qty | Jul Qty | Aug Qty | Base (max of 3 mth) |
CAFÉ 1 | ITEM 1 | 10 | 14 | 12 | 14 |
CAFÉ 1 | ITEM 2 | 15 | 1 | 15 | |
CAFÉ 1 | ITEM 3 | 22 | 24 | 24 | |
CAFÉ 2 | ITEM 1 | 123 | 221 | 243 | 243 |
CAFÉ 2 | ITEM 2 | 4 | 20 | 28 | 28 |
CAFÉ 2 | ITEM 3 | 5 | 126 | 183 | 183 |
CAFÉ 3 | ITEM 1 | 1 | 1 | 13 | 13 |
CAFÉ 3 | ITEM 2 | 12 | 14 | 11 | 14 |
CAFÉ 3 | ITEM 3 | 7 | 4 | 24 | 24 |
Solved! Go to Solution.
@bicoffee
I suggest you to create a qty measure and put those field in a matrix visual.
Measure = MAX([Qty])
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@bicoffee
I suggest you to create a qty measure and put those field in a matrix visual.
Measure = MAX([Qty])
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
HI,
I am having data in the below format...
Hi @bicoffee ,
On power query, there is a function under Add Column->Statistics->Maximum
You just need to select all the coulmns you want to include on getting the Max value and perform the function.
Hope this helps.
If your current table name or last step is named LastStep, you can add a new step, and in the formula bar, type:
= Table.AddColumn(LastStep, "MaxValue", each List.Max(Table.ToRows(LastStep))
--Nate