Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
only_me321
Frequent Visitor

Replace values with values in other column

table example

only_me321_2-1675066206254.png

 

I need this 

only_me321_0-1675065937848.png

 

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 

only_me321_1-1675066093052.png

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

 

help me please,

thank you.

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

 

​Column = CALCULATE(MIN([Sup_group]),ALLEXCEPT('Table','Table'[Group]))

 

If I answered your question, please mark my post as solution, Appreciate your Kudos!

View solution in original post

4 REPLIES 4
Ahmedx
Super User
Super User

 

​Column = CALCULATE(MIN([Sup_group]),ALLEXCEPT('Table','Table'[Group]))

 

If I answered your question, please mark my post as solution, Appreciate your Kudos!

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

thank you, I tried to follow you result is  

only_me321_1-1675070785449.png

 

which i want like this

only_me321_2-1675070796689.png

 

You are doing something wrong, look at my file
https://dropmefiles.com/XruU9

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.