Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum column values based on another column

Hi   I have a logging tool that reports me these column in the table "IMPORT" [date][time][table][rows loaded]   So for example 01/10/2018 - 16:30 - table x - 100 01/10/2018 - 16:30 - table y ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

     Hi,

     

    Try using this formula to create a calculated column and use this new calculated column for your purpose.

     

     

    LastLoadedRowCount = IF('Import'[Time]=MAXX(FILTER(ALL('Import'),EARLIER('Import'[Table])='Import'[Table] && EARLIER('Import'[Date])='Import'[Date]),'Import'[Time]),1,0) *'Import'[RowsLoaded]

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 Hi,

 

Try using this formula to create a calculated column and use this new calculated column for your purpose.

 

 

LastLoadedRowCount = IF('Import'[Time]=MAXX(FILTER(ALL('Import'),EARLIER('Import'[Table])='Import'[Table] && EARLIER('Import'[Date])='Import'[Date]),'Import'[Time]),1,0) *'Import'[RowsLoaded]

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Hi
    Indeed it does work. However having a calculated column is memory intensive and I wanted to have it as a measure (also because I'm learning dax and trying to make it work)