The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, I have something like this. I have a 7 columns under which one in index called "Index" and the rest 6 columns from "SRG" to "SFO". I have 4 rows under "Index" called A,B, C and D. I want to add 4th row called as "D" highlightened in Green as seen where it calculates C/A (C divided by A) but only for columns SRG, PTS and ACSP and C + A(C added to A) for colums SNPT, ARG% and SFO. The question is how do I create a row "D" under "Index" Column in Power BI.
You want to append a new row in table or the resultset ?
Hi Amit,
I want to append a new role in the table but the challenge is the columns like SRG, SFO etc are all measures as well.
So, is there a way where I can create row based on row by row caluclation for a measure.
Appreciate your help.
@Anonymous
ifI understand you correct, you can create a calculated column
CellFormat = IF([Index]="D", "Green", "Black")
the use a conditional formatting option which great described here https://docs.microsoft.com/en-Us/power-bi/desktop-conditional-table-formatting#color-by-color-values (Use Color by color values option)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi @az38 , yes that should be fine with respect to color prespective but wanted to know how to compute row D under Index Column where it computes rows C / A for the first 3 columns and C + A for the next 3 columns.
Appreciate your help!
@Anonymous
it depends on your data model, but as first suggestion you shoulduse the new ACSP column, for example, which is
New ASCP =
var _ASCP_C = LOOKUPVALUE([ASCP], [Index], "C)
var _ASCP_A = LOOKUPVALUE([ASCP], [Index], "A)
RETURN
iF([Index]="D", DIVIDE(_ASCP_C,_ASCP_A), [ASCP])
do not hesitate to give a kudo to useful posts and mark solutions as solution
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |