Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help Date visualization

Hello experts there, 

I have some issues when visualize this. 

I have 1 monthly Budget table, with 3 versions: BU, R1 and R2.

For 2021 table contains only R1 & R2, no BU

For 2021, I only have R1 and R2, it visual correctly when i filter verion

I have problem with 2022. 

For 2022, table only contains BU, no R1 or R2 yet. 

I cant understand this. Do you have any idea? how can i display 2022 BU in this case? 

 

thanks for you advises 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi Anonymous ,

     

    Can you share the calculation that is populating your [BUR1R2] column please?

     

    Pete

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi BA_Pete 

      I cal BUR1R2 using USERELATIONSHIP

       

       

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        4 years ago

        Hi  Anonymous,

         

        Which key column do you use to connect table "BUDR1R2" and Calendar?

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my reply as a solution!