Issue with IFERROR Not Catching Errors Row by Row When Using YIELD in Power BI
Hello, I'm experiencing an issue with the YIELD function in Power BI. I'm trying to calculate the yield, but it seems that IFERROR is not catching errors on a row-by-row basis and assigning values when an error is detected. Here are snapshots of my Excel and Power BI setup: Excel Snapshot: Power BI Snapshot: The formula I'm using in Power BI is: YIELD = YIELD(test[SETTLEMENT_DATE], test[MATURITY], test[COUPON], test[LAST_PRICE], test[PAR], test[Freq]) All columns seem to have the correct data types, but I still encounter #ERROR values. In Excel, I get #NUM! and some valid yield values as expected. However, in Power BI, I was expecting it to show results row-by-row and leave blank if there's an error, instead of showing an error for the whole column. I tried wrapping the YIELD function with IFERROR, but it doesn't seem to handle the errors as expected. Is there any way to make Power BI show the result row-by-row and leave the cell blank if it encounters an error? Attached the data here for reference SETTLEMENT_DATE MATURITY COUPON LAST_PRICE PAR Freq 07/30/2024 07/31/2024 11.00% 9 100 4 07/30/2024 08/31/2024 9.40% 94 100 4 07/30/2024 08/31/2024 9.40% 95 100 4 Thank you!
Calculating yield for production data
Hi all, I'm trying to calculate % yield for some test rig data. Each product, identified by a unique serial number goes through the test and gets a pass of fail result. What I want to do is use the latest test date for each serial number (as each serial number may have gone through multiple tests) and count the amount of pass results. I then plan to divide this number of records by the total number of unique serial numbers in order to get my % yield figure. Here is a sample of the data: VIDATE VITIME SERIAL_NUMBER TEST_OUTCOME 17/07/18 15:27:38 670W16 PASS 17/07/18 15:38:29 670W16 FAIL 17/07/18 15:40:20 670W16 PASS 17/07/18 15:41:34 670W16 PASS 14/09/17 11:56:07 5087W3 PASS 21/09/17 9:23:53 5062H6 PASS 14/09/17 11:54:07 5057H8 PASS 05/07/17 7:59:39 357R35 FAIL 11/07/17 12:31:16 357R35 FAIL 02/03/17 10:24:00 357R35 PASS
