Help with Switch function needed

[Hierkommtnils]

Hi, I was trying to get a visual which shows values based on delivery dates or trading dates. Between those two dates the report viewer should be able to switch via slicer.

Example table:

Trade_Date | Delivery_Start_Date | Value

01.05.2024  | 01.01.2025              | 200

01.05.2024  | 01.10.2024              | 75

02.05.2024  | 01.01.2025              | -50

02.05.2024 | 01.10.2024     | -30

...

I have created a tabel called DateSwitch:

Now I try to use this as a measure:

But it doesnt work, as he seems to search for a single value. Any ideas?

Thanks

Cheers Nils

[lbendlin · Accepted solution]

Please use Field Parameters for this.

[Hierkommtnils]

Thanks, that was the missing part!