Forum Discussion
Create a custom column
Hi Anonymous ,
Based on your description, I suggest you to use DAX Union function to create a calculated table. See Below:
This is the imported Excel Table named “Sheet1”:
This is the DAX formula:
Table = UNION ( SUMMARIZE ( Sheet1, Sheet1[Column 1] ), SUMMARIZE ( Sheet1, Sheet1[Column 2] ) )This is the Return:
Best Regards,
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Based on your description, I suggest you to use DAX Union function to create a calculated table. See Below:
This is the imported Excel Table named “Sheet1”:
This is the DAX formula:
Table =
UNION (
SUMMARIZE ( Sheet1, Sheet1[Column 1] ),
SUMMARIZE ( Sheet1, Sheet1[Column 2] )
)
This is the Return:
Best Regards,
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, thanks for your help, this is the results i'm looking for. However is still can't get it to work.
I've created a table that exactly matches your example. I will try to explain it step by step.
This is how it looks in the Data view:
Then I go back to the Report view and hit the New measure button.
I type in the formula you send me. At first I was getting a syntax error but I think that was due to a regional setting, it seems like I need to use semi-colon instead of comma.
I then click on Matrix
I then try to drag and drop the measure I created. However it wont let drop in it either Rows or Columns.
If I drop in the Values field, I get the following error:
HI, Anonymous
The formula that I provided is only available for creating Calculate Tables.
Thanks! This works.