Forum Discussion
Time intelligence Power BI measure
For my BI report I am trying to show in a visual the values of all opportunities created, historically. The goal is to show the values of an opportunity only for the period it was active. (From the C...
Hi AG24
I see you are using 3 columns to connect the table, please use only one primary key to join to prevent ambiguity.
You can find usefull videos here.
https://www.youtube.com/watch?v=cN8AO3_vmlY&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!
🚀 Attendee Registration Now Open!!!
📢 Microsoft Analytics Community Conference: Microsoft Fabric, Copilot and Purview
🗓️ November 12th-14th, 2024
🌐 Online Event
Register Here
I understand the challange. Unfortunatelly I cannot change the relationships between tables or minimize them. Potentially I can create a separte Date table, not part of the dataset that I am currently using.