Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |