Forum Discussion
summarize table and add new columns
I have a tall table: ID Status date 1 1 01-Jan 1 2 02-Jan 2 1 03-Jan 2 2 08-Jan 2 3 11-Jan 2 2 16-Jan 3 1 21-Jan 3 2 26-Jan 3 4 28-Jan 3 5 31-Jan I would like to make a short table, like this (each St...
hi, Anonymous
I'm afraid it is difficult achieve in DAX, this has changed table structure. and unless you use use a matrix visual to show the result and do not show current value in visual.
here is the pbix file, please try it.
Best Regards,
Lin
Love it!! Can this be done in DAX?
v-lili6-msft
Community Support
Community Supporthi, Anonymous
I'm afraid it is difficult achieve in DAX, this has changed table structure. and unless you use use a matrix visual to show the result and do not show current value in visual.
here is the pbix file, please try it.
Best Regards,
Lin