Forum Discussion

Kesavaraman's avatar
Kesavaraman
Frequent Visitor
3 years ago

Excel formula to DAX

Hi Demand-ID   Demand Supply OS Flag Unfulfilled Total Supply Supply Zero/Non-Zero Total Unfulfilled Unfulfilled Zero/Non-Zero 1   4 2 N 2 4 Non-Zero 0 Zero 2   10 7 N...
Need Help
Show and Tell
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.

  • Kesavaraman's avatar
    Kesavaraman
    Frequent Visitor
    3 years ago

    Hi

     

    Row no.Demand-ID DemandSupplyOS FlagUnfulfilledTotal SupplySupply Zero/Non-ZeroTotal UnfulfilledUnfulfilled Zero/Non-Zero
    1200027_MS-106365_202230 0.050.05N02.05Non-Zero-2Non-Zero
    1300027_MS-106365_288764 0.10N0.12Non-Zero-1.9Non-Zero
    1400014_MS-106365_305428 42N22Non-Zero2Non-Zero
    1500027_MS-106365_202230  2Y-2DNCDNCDNCDNC
    1600027_MS-106365_288764  2Y-2DNCDNCDNCDNC
    1700014_MS-106365_305428  0Y0DNCDNCDNCDNC

     

     

    Here the formula  used for total supply is =IF(F12="N", E12+XLOOKUP(B12,$B$12:$B$17,$E$12:$E$17,"NA",0,-1),"DNC")

     

    and I need to import this total supply column in powerbi so I need a suitable dax