Forum Discussion
Slicer doesn't affect matrix
Apologies, I tried this again on my own computer the issue is the dat_date is marked as a date table which makes complete sense but however it is causing your problem.
What you need to do copy the code for dat_table and then remove it from your model, then stick it back in again but this time don't mark dat_date column as a date table. Then make sure dat_date is formatted as below...
This should do the trick.
Now make the relationship you were looking to make to 'betriebstag' but make sure 'betriebstag' is in the same format as dat_date.
Hopefully this should work!
Helper IIIApologies, I tried this again on my own computer the issue is the dat_date is marked as a date table which makes complete sense but however it is causing your problem.
What you need to do copy the code for dat_table and then remove it from your model, then stick it back in again but this time don't mark dat_date column as a date table. Then make sure dat_date is formatted as below...
This should do the trick.
Now make the relationship you were looking to make to 'betriebstag' but make sure 'betriebstag' is in the same format as dat_date.
Hopefully this should work!
Thanks!! 🙂