multiple date tables to only use 1 date. How?

[philmorris]

I have 6 data sets, all with graphs. I need them all to use 1 date, but each time i make the date table it doesnt work. 

I have tried user relationship which retrns an incorrect syntax error message. I have tried makij gthe relationship between dates and calender table.

I am really stuck and cannot understand why it wont work.

I need to have a global date so that i can make trend vizulationsions with one date, but different metrics from all the 6 data sets i have included.

Any help would be great

[v-xinruzhu-msft]

Hi @philmorris 

You can consider to change the filter direction to both, you can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#cross-fi...

If the solution cannot meet your requirement, can you provide some sample data and the output you want, and please hide your private information.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[philmorris]

Hi,

these are 2 data sets. Notices report and Late notices. I want to replace the issue date with a calendaer table date and count the local ref.

I changed the directin to both and now blanks. I need the top left date to be calender date to run both visuals.

Thanks

[v-xinruzhu-msft]

Hi @philmorris 

Do you want to calculate the sum of the number of local refs that match the selected date in the two tables based on the date selected in the date table?

Best Regards!

Yolo Zhu

[philmorris]

Hi @v-xinruzhu-msft 

I want to count them. I want to put both data sets on 1 line chart eventually using the 1 date from the calender, as well as individual graphs using 1 slicer.

Thanks