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 all,
This is my table.
I would like to fill the EDU column based on the New Daily usage type.
For eg: If 'New Daily usage type' = ADU then 'EDU' = 16.25
If 'New Daily usage type' = FDU the 'EDU' = 39
and so on...
How can I achieve that in DAX?
Any help is appreciated!
Thank you!
Megha
Solved! Go to Solution.
Hi @Anonymous ,
In case this is, what you are looking for...
... you can try this DAX:
EDU = IF ( 'Table'[New Daily Usage Type] = "FDU", 'Table'[FDU], IF ( 'Table'[New Daily Usage Type] = "Blend", 'Table'[Blend], IF ( 'Table'[New Daily Usage Type] = "ADU", 'Table'[ADU], BLANK() ) ) )
Hope this helps!
/Tom
https://www.instagram.com/tackytechtom
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @Anonymous ,
In case this is, what you are looking for...
... you can try this DAX:
EDU = IF ( 'Table'[New Daily Usage Type] = "FDU", 'Table'[FDU], IF ( 'Table'[New Daily Usage Type] = "Blend", 'Table'[Blend], IF ( 'Table'[New Daily Usage Type] = "ADU", 'Table'[ADU], BLANK() ) ) )
Hope this helps!
/Tom
https://www.instagram.com/tackytechtom
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
you can use nested if to fill that coloumn
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |