Forum Discussion
Need help with excel to dax
Hi very new to power BI and was wondering if someone can please help me convert this excel formula to Dax ASAP...
IFERROR($N9/SUMIFS($N$9:$N$170,E$9:E$170, E9), "")
N = resource maturity impact
E-= proj keu
Please help explain how i can write this as a dax.
1 Reply
Hi Anonymous ,
Please refer to this case.
https://community.powerbi.com/t5/Desktop/SUMIF-Equivalent-in-DAX/td-p/230727
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
