how to add columns in a dimension

Anonymous — Fri, 16 Dec 2022 05:33:06 GMT

Hi, experts, I have a problem in display some measures, here is the data:

but the visual should be like this, a summary of top 3 months should be added, and similiary the gap of sum(202201-202206）and sum(202207-202212) should be added in a column

so how to add such a summary value in rows of yearmonth column? Thank you.

Re: how to add columns in a dimension

pi_eye — Tue, 13 Dec 2022 11:45:15 GMT

Hi Anonymous

To display only months 1-3, and only add those up in a total, you can apply a filter to the measure

See table below:

Calc1,2 and 3 are:

calc1 = CALCULATE(sum(Sheet1[cal1]) ,filter(Sheet1,Sheet1[yearmonth]in{202201,202202,202203}) )

calc2 = CALCULATE(sum(Sheet1[cal2]) ,filter(Sheet1,Sheet1[yearmonth]in{202201,202202,202203}) )

calc3 = CALCULATE(sum(Sheet1[cal3]) ,filter(Sheet1,Sheet1[yearmonth]in{202201,202202,202203}) )

What did you mean by the gap of the sums? As an extra column in addition to the total?

topic Re: how to add columns in a dimension in DAX Commands and Tips

how to add columns in a dimension

Re: how to add columns in a dimension