Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My data has a calculated field for Return of Investment = (MTD op income/Days in month)*365/MTD Net Investment)
My DAX = CALCULATE ( MAX (CoName ) = "RETURN ON INVESTMENT",
DIVIDE (
DIVIDE (
CALCULATE (
SUM ( Tbname'[ThismonthAmount] ),
FILTER (
ALLSELECTED ( Tname),
'Cname = "OPERATING INCOME"
)
),
dayscount,
0
) * 365,
CALCULATE (
SUM ( Tbname'[ThismonthAmount] ),
FILTER (
ALLSELECTED ( Tbname),
'colname = "NET INVESTMENT"
)
),
0
My issue is the Net Investment at times is negative and so is operating income. I need to add condional stament to check (
Both operating income and net investment are negative. ROI % should be negative.
when negative Net Investment & Positive Operating Income ROI % should show as 9999.99). I have created variable for both operating income and net investment . Can someone please help me with the DAX that first check the above condition and based on that applies a negative sign or inserts 9999.99
TIA
Solved! Go to Solution.
Thanks @VahidDM
I tried both options and the issue is at times i get 9999.00 and the first condition gives 0 or vice versa am I incorrectly applying it TIA
Hi @Anonymous
You need to create measue like this by using those variables:
Final ROI % = if([Net Investment]<0&&[Operating Income]<0,ABS(ROI %)*-1,if([Net Investment]<0&&[Operating Income]>0, 9999.99,ROI %))
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
Thanks @VahidDM
I tried both options and the issue is at times i get 9999.00 and the first condition gives 0 or vice versa am I incorrectly applying it TIA
Hi @Anonymous ,
Could you please share sample data or PBIX file without sensitive data?
Best Regards,
Winniz
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |