Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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=11350...
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...
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |