Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate Table/SummarizeColumns grouping by date

Hello, I want to export via Dax Studio the following data structure   Day|Product|ProductCategory|SalesAmount   My original data has Datetime|Product|ProductCategory|SalesAmount   Can I perform...
Need Help
Show and Tell
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous ,

     

    You may refer to the DAX below.

    Table =
SUMMARIZECOLUMNS (
    data[Datetime].[Date],
    data[Product],
    data[ProductCategory],
    "Amount", SUM ( data[SalesAmount] )
)
MFelix's avatar
MFelix
Super User
7 years ago

Hi Anonymous ,

 

Can you share some sample data and expected result?

 

Regards

 

MFelix