Forum Discussion

ctrlaldelight's avatar
ctrlaldelight
Frequent Visitor
6 months ago
Solved

Order Projects by date

I have one project where my database is an online Excel file, but the projects are sorted alphabetically rather than by date. I would like to sort them by ‘DATA FIM DE OBRA.’ Is this possible? ...
Need Help
  • MFelix's avatar
    MFelix
    6 months ago

    Hi ctrlaldelight ,

     

    Add the Data da Obra Column before the Projecto ojn the Category. If you want you can hide that column just resizing the column or do a hierachy layout

     

    Please see file attach.

ctrlaldelight's avatar
ctrlaldelight
Frequent Visitor
6 months ago

I created a new table:

DimProjects =
FILTER(
SUMMARIZE(
“Projects”,
“Projects”[Project],
‘MaxEndDate’, MAX(“Projects”[End Date])
),
NOT ISBLANK(“Projects”[Project])
)

And I created a relationship between this table and the other table in the Projects column Cardinality → One to Many (1:*)

Filter direction → Single I sorted the Projects column in the DimProjects table by FimObraMax and kept it sorted alphabetically