Forum Discussion
Solved
Dax Calculated Table
I am trying to take the sample dataset:
| ID | Location | Number Bracket |
| 123 | North America | $101-$250 |
| 233 | North America | $251-$500 |
| 433 | EMEA | $101-$250 |
| 697 | APAC | $501-$1000 |
And create a calculated table in DAX that performs the following:
| Index | Bracket | North America | APAC | EMEA |
| 1 | $101-$250 | 1 | 0 | 1 |
| 2 | $251-$500 | 1 | 0 | 0 |
| 3 | $501-$1000 | 0 | 1 | 0 |
Essentially creating a pivot table. Let me know if this is possible. Thank you!
Hi botaac simpe click add new table and use ADDCOLUMNS (SUMMARIZE pattern with your columns and measures like https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?WT.mc_id=DP-MVP-4025372
I hope this help
1 Reply
Hi botaac simpe click add new table and use ADDCOLUMNS (SUMMARIZE pattern with your columns and measures like https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?WT.mc_id=DP-MVP-4025372
I hope this help