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 a groupby with a summarizecolumns to retrieve the sales by day without creating any new columns?

 

I tried something like this, but it doesnt work

 

EVALUATE
GROUPBY(
SUMMARIZECOLUMNS(
"Date",INT(data[Datetime]),
data[Product],
data[ProductCategory]),
"SlsAmount",CALCULATE(SUM(data[SalesAmount))
)
[Date],
[Product],
[ProductCategory]

 

Ty,

João

 

 

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

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi Anonymous ,

     

    Can you share some sample data and expected result?

     

    Regards

     

    MFelix

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous ,

     

    You may refer to the DAX below.

    Table =
SUMMARIZECOLUMNS (
    data[Datetime].[Date],
    data[Product],
    data[ProductCategory],
    "Amount", SUM ( data[SalesAmount] )
)