Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have two fields in the same table called orders. The two fields I want to evaluate by record are Date_collected and planned_to_date.
I want the set analysis to only include records that are Date_collected<=Planned_to_date
ie
count({<ColYear={"$(=year(Today()))"},Units={"t"},Date_collected<=Planned_to_date>}[Collection Code])
Thanks