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.
First of all, thanks for the help. What I want is to add all those amounts that make up "Sueldos y Salarios" (Wages, Comision, Goals, etc) that are in one column but that do not take what are indeminzations, which is within "Saldos y Salarios" but with another breakdown in another column.
Formula that I am currently using and that indeminzations are included:
The breakdown of indeminations is as follows:
How can I continue to add all the concepts of "Salarios and Sueldos" except those that are "1.3 Indemnizaciones"
Thanks!!!
Solved! Go to Solution.
@4pepesanchez4
You can use a similar pattern as follows:
M =
CALCULATE (
[total sales],
Customer[Gender] = "Male",
Customer[Cars Owned] <> 2
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
You can use the conditional column button under add column. Just create a new column where if your categorization column indicates exclusion, put null or 0, otherwise the value of the column you want to sum. Then just sum that new column.
@4pepesanchez4
You can use a similar pattern as follows:
M =
CALCULATE (
[total sales],
Customer[Gender] = "Male",
Customer[Cars Owned] <> 2
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.