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])

VijayP's avatar
VijayP
Community Champion
6 years ago

Anonymous 

If I have understood your question , please let me know do you want this information shown in the belwo pic?

Vijay Perepa