Forum Discussion

Mohammed-'s avatar
Mohammed-
Resolver I
2 years ago
Solved

IF Statemenr Based in 2 column differnt Type

Hi ,

 How to Convert This DAX Code to add custom column in power query

 

 Acc Lev 2 = SWITH(TRUE( ),
                    F0901[GMOBJ] =1101 && F0901[GMSUB] =1000 , "A/R & Others",
                    F0901[GMOBJ] =1101 && F0901[GMSUB] =2000 ," A/R & Others",
F0901[GMOBJ] =1101 && F0901[GMSUB] =2500 ," A/R & Others",
F0901[GMOBJ]=1101 && F0901[GMSUB]<1000 && F0901[GMOBJ]<1130 ,"Cash&Banks",
       
Please notes GMOBG Column type Whole Number & GMSUB Column Type Text
Tutorial Requests
  • Mohammed-'s avatar
    Mohammed-
    2 years ago

    Hi PijushRoy 

    Thanks for your replay  and i am so sorry for delay  you   the problem ther is some Account include text  any way i changed  the type 

    thank you very much

2 Replies

  • Mohammed-'s avatar
    Mohammed-
    Resolver I
    2 years ago

    Hi PijushRoy 

    Thanks for your replay  and i am so sorry for delay  you   the problem ther is some Account include text  any way i changed  the type 

    thank you very much

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Mohammed- 

    Please change Datatype of the GMSUB text to number in PQ
    Then use below formula in Custom Column

    = if [GMOBJ]=1101 and [GMSUB]=1000 then "A/R & Others" else if [GMOBJ]=1101 and [GMSUB]=2000 then "A/R & Others" else if [GMOBJ]=1101 and [GMSUB]=2500 then "A/R & Others" else if [GMOBJ]=1101 and [GMSUB]<1000 and [GMOBJ]<1130 then "Cash&Bank" else null

    Change the logic as per your requirement, I hope you find the logic

    Please revert change Datatype of the GMSUB number to text in PQ

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, please THUMBS UP 👍 this comment


    Thanks
    Pijush

    Follow www.MyAccountingTricks.com 
    Youtube - https://www.youtube.com/channel/UCWWGZXYYq_TmV6UPiC3ujkQ