Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

multiple date tables to only use 1 date. How?

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

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

    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-filter-direction

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

        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