Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
How to Convert This DAX Code to add custom column in power query
Solved! Go to 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
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
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