Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
1 year ago
Solved

Last 3 quarter

I have a data set in which contain Sales amount, Name of manager, Report pull date, Quarter I need to build a Matrix table that will show last 3 quarter sales for each manager based on the Quarter s...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi unnijoy,

    Thank you for your follow up.

    Please find attached a screenshot and a sample PBIX file that may help resolve the issue:


    We hope the information provided is useful. If you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi unnijoy,

Thank you for your follow up.

Please find attached a screenshot and a sample PBIX file that may help resolve the issue:


We hope the information provided is useful. If you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

  • unnijoy's avatar
    unnijoy
    Post Prodigy
    1 year ago

    v-pnaroju-msft Thank you very much. Its working.  😊

  • unnijoy's avatar
    unnijoy
    Post Prodigy
    1 year ago

    v-pnaroju-msft  in this table insted of the numbers if i need to showe the grand total % how should i do that.