Distinct count -sum

[Anonymous]

Hello

i have couple of questions.

can we group column based on measure  show in pic.

can column labels change dynamically when month changes in last 3 months for measure a ^& measure ?B

[V-pazhen-msft]

@Anonymous 

It is recommended to create measures based on the existing columns to make visuals dynamically change.

Best regards
Paul Zheng

[camargos88]

 @Anonymous ,

Have you thought about using matrix instead of table ?

You can use a column value as header, it will give you a dinamic header based on your column values.

Ricardo

[edhans]

No. Column lables cannot dynamically change. You can have dynamic text in a Card using normal text formulas, but column and row labels are based on the database you have loaded. You can conditionally format the data using measures to determine if it was changed in last 3 months, but that changes the format of the values, not the column info.