Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Set a column value (not affecting the sheet filter)

Hello, I need to get the following table, that when filtered by "X" date only what was purchased will be modified, which would come being the accumulated to date. I have the following tables:

- Customer, with name detail, etc.

- Purchased, date, customer, amount

- Proposed, date, customer, amount (the table should show the total of this per customer)

ClientBoughtProposedPercentage

A

3080= 100 * 30/80
B4070= 100 * 40/70
C2090= 100 * 20/90

Firsthand thank you very much.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Please provide sample data in usable format and show the expected outcome.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Syndicate_Admin ,

     

    Your data model is complex and the sample data you currently provide cannot help solve your problem, so please provide a sample .pbix file or complete sample data.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.