topic help me please!! need to create a new column based on other columns in power bi in DAX Commands and Tips

help me please!! need to create a new column based on other columns in power bi

Anonymous — Mon, 30 Jan 2023 08:21:49 GMT

table example

I need this

The DAX I wrote is

New_Column = CALCULATE(MIN('table'[Sup_group]),FILTER(ALL('table'),
'table'[province] = EARLIER('table'[province]) &&
'Stable'[Quarter] = "Q1"))

The result is

But I don't want this kind of result, I want like the first picture.

help me please,

thank you.

tamerj1 — Mon, 30 Jan 2023 08:44:20 GMT

Hi Anonymous
Please try

New_Column = MINX ( TOPN ( 1, CALCULATETABLE ( 'table', ALLEXCEPT ( 'table', 'table'[province] ) ), 'Stable'[Quarter], ASC ), 'table'[Sup_group] )

Anonymous — Mon, 30 Jan 2023 09:22:41 GMT

thank you, I tried to follow you result is

which i want like this

Anonymous — Mon, 30 Jan 2023 09:35:20 GMT

Oh, I can do it, just like you let me try. 😍