Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

how to sort a summarized table

Hello,

 

Here's my summarized table and I would like to sort it using the key field.  How do we do that?

 

Working Table II =


Summarize('Project''s Info','Project''s Info'[Key],'Project''s Info'[projectskey],'Project''s Info'[ProjectID],'Project''s Info'[ProjectWBS1], 'Project''s Info'[fiscalPeriod],'Project''s Info'[JTDBudgetRevenueAmt],'Project''s Info'[MTDRevenue],'Project''s Info'[JTDRevenue],'Project''s Info'[JTDBacklogAmt],'Project''s Info'[% Month Complete],'Project''s Info'[**bleep** % Month Complete],'Project''s Info'[Time Bucket])
 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous - In general sorting in DAX is tricky at best if not impossible. Can I ask why you need to sort it? If you are creating this table in the model, you can sort it in the Data view just like any other table by right-clicking a column.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - In general sorting in DAX is tricky at best if not impossible. Can I ask why you need to sort it? If you are creating this table in the model, you can sort it in the Data view just like any other table by right-clicking a column.