Forum Discussion

Ormy28's avatar
Ormy28
Regular Visitor
1 year ago
Solved

Add New Columns to Summary Table

Hi   I'm quite new to DAX, so there might be a straightforward solution to this.   I have a table of data as below, with dates and a colour. ID Week Start Colour 1 07/04/2025 Red 2 ...
Need Help
Tips and Tricks
  • PijushRoy's avatar
    PijushRoy
    1 year ago

    Hi Ormy28 

    Plase use below DAX 

    DynamicSummary =
SUMMARIZE(
    'Table', 
    'Table'[Week Start], 
    'Table'[Colour],
    "Count", COUNT('Table'[ID])
)

     

     

PijushRoy's avatar
PijushRoy
Community Champion
1 year ago

Hi Ormy28 

Plase use below DAX 

DynamicSummary =
SUMMARIZE(
    'Table', 
    'Table'[Week Start], 
    'Table'[Colour],
    "Count", COUNT('Table'[ID])
)

 

 

Ormy28's avatar
Ormy28
Regular Visitor
1 year ago

Excellent, thanks for the help. A straightforward and logical solution.