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
Hi Everyone,
I have data for Teams in East and West (as seen in atatched image) but unsure on how to make a table like below:
Essentially to look like this:
Conference | Win | Loss |
East | 564 | 176 |
West | 567 | 199 |
Thank you for your help! 🙂
Solved! Go to Solution.
@NiallMoo - You could do as:
NewTable = ALLNOBLANKROW(TableName[Conference])
then add new columns like:
W Column =
SUMMARIZE(
FILTER(TableName,TableName[Conference] = 'Table'[Conference]),
"@Sum",SUM(TableName[W])
)
L Column =
SUMMARIZE(
FILTER(TableName,TableName[Conference] = 'Table'[Conference]),
"@Sum",SUM(TableName[L])
)
Proud to be a Super User!
@NiallMoo - You could do as:
NewTable = ALLNOBLANKROW(TableName[Conference])
then add new columns like:
W Column =
SUMMARIZE(
FILTER(TableName,TableName[Conference] = 'Table'[Conference]),
"@Sum",SUM(TableName[W])
)
L Column =
SUMMARIZE(
FILTER(TableName,TableName[Conference] = 'Table'[Conference]),
"@Sum",SUM(TableName[L])
)
Proud to be a Super User!
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 |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |