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
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 | |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
