Forum Discussion

Sofinobi's avatar
Sofinobi
Helper IV
2 years ago
Solved

Force Summarize Table

Good morning all, please, i have 3 tables ; "Sales_Tab" as fact,                                      "ThirdParty" as dim, and Date Table i want to create a summarized table with 3 columns ; Clien...
Help
  • lbendlin's avatar
    lbendlin
    2 years ago
    Summarize Table = ADDCOLUMNS(SUMMARIZECOLUMNS(Client[Oid],'Date'[Month]),"Sales", calculate(0+SUM(Sales[Amount])))
     

     

Sofinobi's avatar
Sofinobi
Helper IV
2 years ago

please, any advice?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    Summarize Table = ADDCOLUMNS(SUMMARIZECOLUMNS(Client[Oid],'Date'[Month]),"Sales", calculate(0+SUM(Sales[Amount])))
     

     

    • Sofinobi's avatar
      Sofinobi
      Helper IV
      2 years ago

      thank you my friend for you answer, it works perfectly
      thank you again.