Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |