Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have the following table and I need to know how i can add new column (Type2) based on the following:
if one of the Type column values for the same BithdayID is Creative then all values in Type2 column for the same BirthdayID should be Creative otherwise Type2 should be Basic. The following table illustrates the disiered results in Type2 column.
Thank you 🙂
BirthdayID | Type | Type2 (New Column) |
Birth-1 | Basic | Basic |
Birth-1 | Basic | Basic |
Birth-4 | Creative | Creative |
Birth-4 | Basic | Creative |
Birth-4 | Basic | Creative |
Birth-7 | Basic | Creative |
Birth-7 | Creative | Creative |
Birth-7 | Basic | Creative |
Solved! Go to Solution.
Hi @RamiDaoud ,
Create following column as follows:
Hi @RamiDaoud ,
Create following column as follows:
The proposed formula works if I add a new column in the default pane but if I want to create similar as custom column in the Power Query Editor than it doesn't work (error) but I have not enough knowledge to find/troubleshoot the issue...if someone maybe so kind 🙂
Thank you!
Hi @RamiDaoud
try a measure
Type2 =
var _isCreative = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[BirthdayID]),'Table'[Type]="Creative")
RETURN
IF(_isCreative>0,"Creative","Basic")
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
107 | |
92 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |