Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hello!
Hope you're doing well. As the images below, I want to return the same value if the column "TipoMultiplicacao" is "EXTERNA" as an alternate result.
In a nutshell is: If "TipoMultiplicacao" is "INTERNA", divide; if "EXTERNA", don't divide and return the same value"
DAX I'm using:
What I want (in red)
Thanks so much!
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
CustoAula CC =
IF (
ReferencialTreinamentos[TipoMultiplicacao] = "Interna",
DIVIDE (
ReferencialTreinamentos[Custo],
ReferencialTreinamentos[NumeroInteriroHoras]
),
ReferencialTreinamentos[Custo]
)
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
CustoAula CC =
IF (
ReferencialTreinamentos[TipoMultiplicacao] = "Interna",
DIVIDE (
ReferencialTreinamentos[Custo],
ReferencialTreinamentos[NumeroInteriroHoras]
),
ReferencialTreinamentos[Custo]
)
It worked perfectly!
Thank you so munch, Jihwan!
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |