I woul like to do the following in power BI,
I did the desired result in Excel (SUMAR.SI.CONJUNTO) but, I would like to do it on Power BI:
Subtype 1 Subtype2 Total1 Total2
Blanco Azul 300 200
Rojo Rojo 400 400
Azul Blanco 200 300
Rosa Amarillo 600 800
Amarillo Rosa 800 600
Naranja Naranja 200 200
.... .... ..... ........
.... .... ....... ......
.... ..... ....... .........
I have the column Total1 but I would like to have the column Total 2:
Total 2: IF SUBTYPE1 (Blanco) = SUBTYPE2 (Blanco) AND SUBTYPE2 (Azul)= SUBTYPE1 (Azul ) THEN 200, PRINT IT ON THE COMBINATION Blaco , Azul = 200
Total 2 = IF SUBTYPE 1 (Rojo) = SUBTYPE 2 (Rojo) THEN TOTAL1
Note: i post a pic i hope i will helps
I really apreciate your help
Go to Solution.
Im sorry for the delay ... but I test it again with all my dataset and it works fine, the problem was the data so I will checked the data consistency.
Thanks a lot
Hi @LuciaSR ,
You can create a calculated column in Power BI.
Data_1[Subtype1] = Data_1[Subtype2],
LOOKUPVALUE ( Data_1[Subtype1], Data_1[Subtype1], Data_1[Subtype2] ) = Data_1[Subtype2],
SUM ( Data_1[Total1] ),
Data_1[Subtype1] = EARLIER ( Data_1[Subtype2] )
&& Data_1[Subtype2] = EARLIER ( Data_1[Subtype1] )
Hi Yuliana Gu,
It works fine in the example but when i replace the solution on my project it doesn´t works.. maybe it has a lot of data
I don´t know...
Did you get any error message?
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!