Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Mohammed-
Helper I
Helper I

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
1 ACCEPTED SOLUTION
Mohammed-
Helper I
Helper I

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

View solution in original post

2 REPLIES 2
Mohammed-
Helper I
Helper I

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
Community Champion
Community Champion

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


Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors