Help with Switch function needed

Hierkommtnils — Tue, 18 Jun 2024 06:57:40 GMT

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

Re: Help with Switch function needed

lbendlin — Wed, 19 Jun 2024 01:30:47 GMT

Please use Field Parameters for this.

Re: Help with Switch function needed

Hierkommtnils — Wed, 19 Jun 2024 07:30:45 GMT

Thanks, that was the missing part!

topic Help with Switch function needed in DAX Commands and Tips

Help with Switch function needed

Re: Help with Switch function needed

Re: Help with Switch function needed