topic Re: Take value from column and fill new column based on condition in DAX Commands and Tips

Take value from column and fill new column based on condition

Mav — Fri, 12 Aug 2022 15:21:45 GMT

Hello,

I'm trying to build a column that is filled with the value from another column.

Fill the column with the total income for that particular month

(For clarity, the value would change depending on the month)

Any suggestions?

Re: Take value from column and fill new column based on condition

Jihwan_Kim — Sat, 13 Aug 2022 12:50:45 GMT

Hi,

Based on what I see on the screenshot, please try the below for creating a new column.

Rev for month CC = MAXX ( FILTER ( 'your table name', 'your table name'[acct] = "Total Income" ), 'your table name'[value] )

Re: Take value from column and fill new column based on condition

Mav — Sat, 13 Aug 2022 18:47:53 GMT

Thanks! We're close, but i need the Income to be displayed for the respective month.

Your code will populate the maximum value for all months.

ie. for all Jan rows, i need Jan income, for Feb rows, I need Feb income etc.

Re: Take value from column and fill new column based on condition

Jihwan_Kim — Mon, 15 Aug 2022 03:01:20 GMT

Hi,

try the below whether it works for your dataset.

If you have more columns to be included in the condition, you can try to add more into the below by using && function.

Rev for month CC = MAXX ( FILTER ( 'your table name', 'your table name'[acct] = "Total Income" && 'your table name'[month] = EARLIER ( 'your table name'[month] ) ), 'your table name'[value] )

Re: Take value from column and fill new column based on condition

Mav — Mon, 15 Aug 2022 12:32:25 GMT

Excellent - Thank you! Exactly what I was looking for.