topic Re: I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP in DAX Commands and Tips

I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP

kana — Fri, 27 Mar 2020 03:03:37 GMT

Dear All Master,

I want a dax formula that replaces if and vlookup. I want the master item sheet not to be unpivoted because the original master item has 30000 records so that if I unpivot it becomes 90000 records. The result I want is in the yellow data sheet. I want to use the buffer function so that it makes data loading fast.

My link file : https://drive.google.com/open?id=1eSCR8jIOZ7VTGHKpfzvgKGA8YNwO9KBm

Thanks

Kana

Re: I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP

baghdadi62 — Fri, 27 Mar 2020 17:01:42 GMT

Hi,

Excel	DAX	Description
IF	IF
IF	Switch
VLookup	Lookupvalue	With or without relationship between tables.
VLookup	Related	If your tables have relationship.

Re: I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP

kana — Sat, 28 Mar 2020 02:52:23 GMT

Dear Sir,

Can you reply with the excel file link that I attached and show the results directly in the excel file with the Dax formula so that I can easily learn.

Thanks

Kana

Re: I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP

kana — Sat, 28 Mar 2020 03:40:56 GMT

My link file : https://drive.google.com/open?id=1eSCR8jIOZ7VTGHKpfzvgKGA8YNwO9KBm

Re: I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP

kana — Sun, 29 Mar 2020 05:03:54 GMT

Dear All Master,

Can anyone help me and reply with the excel file that I attached.

Thanks

Kana

Re: I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP

kana — Wed, 01 Apr 2020 02:47:57 GMT

Dear All Master,

Can anyone help me.

Thanks

Kana

Re: I WANT THE DAX FORMULA AS A REPLACEMENT OF IF AND VLOOKUP

kana — Thu, 16 Apr 2020 06:21:12 GMT

Dear All Master,

Can anyone help me and reply with the excel file that I attached.

Thanks

Kana