topic Re: Need help in creating Dax from the Excel formula in DAX Commands and Tips

Need help in creating Dax from the Excel formula

murugesh_c — Mon, 08 Jul 2024 19:09:24 GMT

IF(AND(A1<0,B2<>""),"SMU",IF(AND(A1>0,B2<>""),"SMU","MUJ"))

Dear Friends, I am struggling in converting the above excel function into a dax in Power Bi. Can anyone please help me in writing the dax query from the function above. It would be a great help and learning for me. Thanks in advance.

Re: Need help in creating Dax from the Excel formula

adudani — Mon, 08 Jul 2024 19:36:33 GMT

hi murugesh_c ,
kindly provide a sample input and sample output.

for now. assuming table name is "Table" and columns are "ColumnA" and "ColumnB"
the measure :

test = IF( AND( 'Table'[ColumnA] < 0 , 'Table'[ColumnA] <>"" ), "SMU", IF( AND( 'Table'[ColumnA] > 0 , 'Table'[ColumnA] <>"" ), "SMU", "MUJ" ) )

rought this would be it.

Re: Need help in creating Dax from the Excel formula

murugesh_c — Wed, 10 Jul 2024 02:46:20 GMT

Hi Avinash,

Thank you for your time.

I have attached a spreadsheet containing sample data and the calculation that I want to incorporate in Power Bi. I have the same dataset in Power Bi and I want to replicate the calculation in Column E in Power Bi. Kindly check and let me know if you can help with a dax.

https://docs.google.com/spreadsheets/d/1zTDLvGKpB36nuXg4BK9JMCQWTCFqmr5B/edit?usp=sharing&ouid=113500676520475250644&rtpof=true&sd=true

Re: Need help in creating Dax from the Excel formula

murugesh_c — Thu, 11 Jul 2024 02:59:43 GMT

Can anyone please help me with the dax calculation? I have attached a spreadsheet containing sample data and the calculation that I want to incorporate in Power Bi. I have the same dataset in Power Bi and I want to replicate the calculation in Column E in Power Bi. Kindly check and let me know if you can help with a dax.

https://docs.google.com/spreadsheets/d/1zTDLvGKpB36nuXg4BK9JMCQWTCFqmr5B/edit?usp=sharing&ouid=11350...