Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Bit boggled by this, I'm trying to get the COUNTROWS of a separate dataset from a tablix but keep running into the rsFieldReference error:
The Value expression for the text box 'Textbox21' refers to the field 'DateStart'. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
This is the formula in question:
=SUM(
IIF(CDATE(Fields!Date.Value) >= CDATE(Fields!DateStart.Value) AND CDATE(Fields!Date.Value) <= CDATE(Fields!DateEnd.Value), 1, 0),
"dsHolidayData")
Any way I can resolve this? The main dataset I'm pulling the DateStart/DateEnd dates is a SQL query and the dsHolidayData dataset is from a PBI dataset connection so I don't think there's a way to do this via a query.
Hi @olimilo ,
Test to delete existing dataset and designed report and re-create it.
Similar question refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.