Forum Discussion
Blitz
8 years agoNew Member
How to generate duplicated rows with multiple values computed column ?
Hi,
I'm searching for days, I can't figure out how to make this:
_example =
ADDCOLUMNS(
FILTER(
SUMMARIZE(_distancial_amont_dates_interval; _distancial_amont_dates_interval[start_date]; _distancial_amont_dates_interval[end_date]);
_distancial_amont_dates_interval[start_date] <> BLANK()
);
"date"; CONCATENATEX(CALENDAR(_distancial_amont_dates_interval[start_date]; _distancial_amont_dates_interval[end_date]); [Date]; "; ")
)
As you can see, I have a table with a column that contains a list of generated dates.
I simply want to have a row per date.
I know I will have a lot of duplicated data, but I need this to make statistics date per date.
Thanks for your help.
2 Replies
- Eric_ZhangMicrosoft Employee
- BlitzNew Member
Thanks for your answer.
I'm not sure to be able to do that on a computed column.
But never mind, I found a quick workaround, but I hope it could help some others.
I generated dates directly in MS Dynamics (it's a bit ugly, but it's light and it works well).
Thanks for your help.
Blitz.