Dax Calculated Table

[botaac]

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!

[some_bih · Accepted solution]

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