Forum Discussion
DAX query to create custom table
We had a dashboard in excel. One of the Summary view had values pulled from different source (Pivot table). Some fields were calculated using simple division etc. I'm trying to replicate the exc...
Greg_Deckler
Community Champion
Community ChampionI would create your datatable but with only a single column, then use ADDCOLUMNS to add your other columns and then you can tie these to just about any calculation.
Hi Greg,
I first created a table using DATATABLE and then tried to ADDCOLUMNS, But I'm unable to perform this operation with this below query. I'm using Summarize to group by a column[INDICATOR] in a table named 'OUT' and then get the SUM(CREDIT_LIMIT).
ADDCOLUMNS(CustomTable, "Total Losses", SUMMARIZE(OUT, OUT[INDICATOR],"Total",SUM(OUT[CREDIT_LIMIT])))