Forum Discussion

palvarez83's avatar
palvarez83
Helper I
7 years ago

Create sort column with duplicates based on another column

  Hello, I have the dimension table dPAU  pictured below that was created with Power Query.  In Power query I sorted the PAU based on the dates on the second column and created an index column dPAU...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi palvarez83 ,

You can take a look at following blog to know how to create a sorting table to achieve your requirement:

Custom Sorting in Power BI

Regard,

Xiaoxin Sheng

palvarez83's avatar
palvarez83
Helper I
7 years ago
Anonymous wrote:

Hi palvarez83 ,

You can take a look at following blog to know how to create a sorting table to achieve your requirement:

Custom Sorting in Power BI

Regard,

Xiaoxin Sheng

Anonymous wrote:

Hi palvarez83 ,

You can take a look at following blog to know how to create a sorting table to achieve your requirement:

Custom Sorting in Power BI

Regard,

Xiaoxin Sheng

Hi,

Yes, I can do it with Power Query index column.  That's what I did for the PAU.... but for the Module I have duplicates and would like to do it with DAX in the data model.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI palvarez83 ,

    If you can please share a pbix file with some sample data and expected result for test.

    Notice: do mask on sensitive data before share.

    Regards,

    Xiaoxin Sheng