Forum Discussion

Sirhawk3017's avatar
Sirhawk3017
Icon for Helper II rankHelper II
1 year ago
Solved

Quartiles based on YTD Sales Measure

Hi All!    I need some help creating quartiles in PowerBI Desktop. I want the quartiles to be based on measure FM Sales YTD. What I want to know is who are the owners that contribute to the top two...
  • rajendraongole1's avatar
    1 year ago

    Hi Sirhawk3017 - I have attached pbix with created new measure for determine quartile boundaries.(1,2,3) , i have choosen a table FM BDC , may be if it is a different table, please check and change.

     

    Hope this helps.

     

  • Sirhawk3017's avatar
    Sirhawk3017
    1 year ago

    looking at this again and it works perfectly. I just needed to change the table. thank you again for your help!