Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Folks,
I need your help, I am new to this platform.
I have data source of sharepoint list.
Here i give you a short explaination about my database.
I have table that contains columns channel,asset type,asset number. I want to create column based on perticular channel and perticular asset type. Please have a look at below table.
Channel | Asset Type | Asset Number |
test | a | 15 |
zee | b | 25 |
lee | c | 19 |
lee | a | 10 |
alem | alem | 58 |
lee | a | 45 |
alem | alem | 85 |
test | b | 05 |
1) now i want to create a new column: Column A that contains number of asset only for asset type a or b. for which i use following
logic in custom column:
if [asset type] = a or [asset type]=b then [asset number] else null.
2) I want to create another column that contains asset number only for which have channel and asset type both as "alem".
i used following logic
if [channel] = "alem" then if [asset type] = "alem" then [asset number] else 0 else null.
Please help to resolve it.
Solved! Go to Solution.
HI @HarpalsinhZala,
You can try to create a calculated column with the below formula if it meets your requirement:
Replaced =
IF (
table[channel] = "alem",
IF ( table[asset type] = "alem", table[asset number], 0 )
)
Regards,
Xiaoxin Sheng
HI @HarpalsinhZala,
You can try to create a calculated column with the below formula if it meets your requirement:
Replaced =
IF (
table[channel] = "alem",
IF ( table[asset type] = "alem", table[asset number], 0 )
)
Regards,
Xiaoxin Sheng
@HarpalsinhZala
Can you try this :
(This is in Power Query)
if [channel] = "alem" and [asset type] = "alem" then [asset number] else 0
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |