max of 3 months

[bicoffee]

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

[V-pazhen-msft · Accepted 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]

HI,

I am having data in the below format...

[mussaenda]

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.

[watkinnc]

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

[bicoffee]