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
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.