IF Statemenr Based in 2 column differnt Type

[Mohammed-]

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

[Mohammed- · Accepted solution]

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]

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