Dynamic Report

[Daivat]

Hi Team,

Let's say I have 3 clients and all of them have different vendors from where they purchase bread for their restaurants in the same city/state. Now, I am looking to prepare a report which can get me the prices of all the 3 vendors so that I can compare and present a detailed report to all my 3 clients and help them save their costs as vendor 1 could be purchasing for $10, vendor 2 for $11 and vendor 3 for $9.5.

What is the best way to present the same? I already have the data.

[Anonymous · Accepted solution]

Hi @Daivat ,

I have created a simple sample, please refer to my pbix file wo see if it helps you.

Create a column.

Column =
RANKX (
    FILTER ( 'Table', 'Table'[subject] = EARLIER ( 'Table'[subject] ) ),
    'Table'[value],
    ,
    ASC,
    DENSE
)

If I have misunderstood your meaning , please provide more details with your desired output and your pbix file without privacy information.

Best Regards
Community Support Team _ Polly

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