Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
Solved! Go to Solution.
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.
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
36 |