Filtering columns in summarizecolumn

[Anonymous]

Hi

I'm trying to filter rows so that  get one value.

The Bonus ($) is calculated by multiplying GL ($) by 0.005

I would like to show the table so that it shows this way

Ref#	Quarter	Month	Sales ($)	GL ($)	Bonus  ($)
30243770-440	2021-Q4	2021-M11	9,53034.86	96,1190.86	4,805.9543
30243770-440	2021-Q4	2021-M12	8,156.00	-	-

Or maybe someone can suggest another way to display same info

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

Summarize =
SUMMARIZE('Table','Table'[Ref#],'Table'[Quarter],'Table'[Month],'Table'[Sales($)],
"GL($)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[GL($)])),
"Bounds($)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[Bouns($)])))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly