DAX

[Anonymous]

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

[tackytechtom · Accepted 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.tackytech.blog

https://www.instagram.com/tackytechtom

[Anonymous]

you can use nested if to fill that coloumn