Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.