Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
4 years ago
Solved

create new table with condition

hi all,   i have a table that looks like following:     i want to create a new table with the restrictions name1 = X and name2 = Y and I want to see the id_2 with MIN(id):     Res...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

Pikachu-Power update your expressions as below, I showed how to add days, you can use the same logic for start and end date

 

New_Table = 
ADDCOLUMNS(
    SUMMARIZE (
        FILTER(
            'Table', 
            'Table'[name1] = "X" && 
            'Table'[name2] = "Y"
        ),
        'Table'[Name1],
        'Table'[Name2],
        'Table'[id_2],
        "min_id", MIN ( 'Table'[id] )
    ),
    "days", var __id = [min_id] return CALCULATE ( min ( 'Table'[days] ), 'Table'[id] = __id )
)

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡