Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated colum

Hi all,   I have a question for this DB: https://www.dropbox.com/s/m8hywr41rn6neq8/example.xlsx?dl=0   I wold have a table: - grouped by Rimorchio: a list of all the contents - Grouped by Tras...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

    Hope I understood your request correctly.

    create a table

    Table = ADDCOLUMNS( SUMMARIZE('Foglio1','Foglio1'[RIMORCHIO],"checkin",CALCULATE(countrows(Foglio1),FILTER('Foglio1',Foglio1[Senza Titolo]="CHECKIN")),"checkout",CALCULATE(countrows(Foglio1),FILTER('Foglio1',Foglio1[Senza Titolo]="CHECKOUT"))),"tot",[checkout]-[checkin])

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

Anonymous 

Hope I understood your request correctly.

create a table

Table = ADDCOLUMNS( SUMMARIZE('Foglio1','Foglio1'[RIMORCHIO],"checkin",CALCULATE(countrows(Foglio1),FILTER('Foglio1',Foglio1[Senza Titolo]="CHECKIN")),"checkout",CALCULATE(countrows(Foglio1),FILTER('Foglio1',Foglio1[Senza Titolo]="CHECKOUT"))),"tot",[checkout]-[checkin])

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Ryan

     

    it works!

    thanks a lot

    a last question:

    how can I had a column to have the greater date relative at the check in?

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      6 years ago

      Anonymous 

      do you want to add the latest checkin date to the new table?

      Table = ADDCOLUMNS( SUMMARIZE('Foglio1','Foglio1'[RIMORCHIO],"checkin",CALCULATE(countrows(Foglio1),FILTER('Foglio1',Foglio1[Senza Titolo]="CHECKIN")),"checkout",CALCULATE(countrows(Foglio1),FILTER('Foglio1',Foglio1[Senza Titolo]="CHECKOUT")),"maxcheckindate",CALCULATE(max('Foglio1'[Data della registrazione]),ALLEXCEPT('Foglio1',Foglio1[RIMORCHIO]))),"tot",[checkout]-[checkin])