Need help Date visualization

Anonymous · ‎10-28-2021

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

BA_Pete · ‎10-28-2021

Hi @Anonymous ,

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

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Anonymous · ‎10-28-2021

I cal BUR1R2 using USERELATIONSHIP

v-kelly-msft · ‎11-02-2021

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!

Anonymous · ‎11-03-2021

Hi Kelly,

it is Date column & date.month YYYY-DD, both date format.

v-kelly-msft · ‎11-03-2021

Hi @Anonymous ,

Can you create a simple sample for test?

Best Regards,
Kelly

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

Helpful resources