Hi all,
Really struggling with this so thanks for looking.
I'm trying to create a summary table by company and want to use a slicer to change the date (which changes the results).
My summary table is called "UniqueOrg" and I have this column:
It looks like it works when the date is hard coded but when I try and change it to look at the slicer I get lots of different error messages.
I've tried the date field in the raw data table, created a date table and added a measure equal what is selected but no luck so far
Any help is much appreciated.
Really struggling with this so thanks for looking.
I'm trying to create a summary table by company and want to use a slicer to change the date (which changes the results).
My summary table is called "UniqueOrg" and I have this column:
VBA Code:
Working = CALCULATE(
COUNT(MAs[Organisation]),
FILTER(
MAs,
MAs[Organisation] = CALCULATE(VALUES(UniqueOrg[Org]))
),MAs[Migration Week] = DATE(2021,06,28)
)It looks like it works when the date is hard coded but when I try and change it to look at the slicer I get lots of different error messages.
I've tried the date field in the raw data table, created a date table and added a measure equal what is selected but no luck so far
Any help is much appreciated.
