Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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:
Example:
Table1
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
Solved! Go to Solution.
Hi Yuliana,
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 @Anonymous ,
You can create a calculated column in Power BI.
Total2 = IF ( Data_1[Subtype1] = Data_1[Subtype2], [Total1], IF ( LOOKUPVALUE ( Data_1[Subtype1], Data_1[Subtype1], Data_1[Subtype2] ) = Data_1[Subtype2], CALCULATE ( SUM ( Data_1[Total1] ), FILTER ( Data_1, Data_1[Subtype1] = EARLIER ( Data_1[Subtype2] ) && Data_1[Subtype2] = EARLIER ( Data_1[Subtype1] ) ) ) ) )
Best regards,
Yuliana Gu
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...
Thanks
Hi @Anonymous ,
Did you get any error message?
Regards,
Yuliana Gu
Hi Yuliana,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |