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,
Go to Solution.
Hi @only_me321 Please try
CALCULATETABLE ( 'table', ALLEXCEPT ( 'table', 'table'[province] ) ),
View solution in original post
Oh, I can do it, just like you let me try. 😍
thank you, I tried to follow you result is
which i want like this
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.