Forum Discussion

Cedbont's avatar
Cedbont
Regular Visitor
2 years ago
Solved

In a visual, get table values updated with another table value

Hi there!   I have got PBIX file that features a table indicating:  - Training courses (courses A, B, C...)  - For each training course, there can be several training sessions (with start and end...
  • Cedbont's avatar
    2 years ago

    Hi all,

     

    I have found a workaround. I would appreciate if you told me this was the best way or not.

     

    Instead of having a link between tables 1-Sessions and 3-Prix (prices), I:

    • Deleted that link
    • Created a new one between 2-Clients and 3-Prix (prices)
    • Created a new price thanks to a new calculated column in 2-Clients that could use as arguments both the reference price located in 3-Prix and the client type located in 2-Clients
    • Called that new price in my table (visual).

     

    Cedbont