Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
It worked perfectly!
Thank you so munch, Jihwan!
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
21 |