Forum Discussion
Group by and summarize
Hi again
It's true that the Gantt chart doesn't accept the measures as input to the start and/or end dates. However, a workaround is just to add the calculations of start and end dates as calculated columns instead and use these in the Gantt chart.
The thing is that - depending on the size of your report - unneccesary tables may affect the performance. And here, I don't think it's necessary.
So just add calculated columns for you start and end dates like this:And use these in the Gantt chart, like this:
I then achieve this Gantt chart visual:
Hope this helps.
Best regards.
Hi Bruno
You can create a measure in which you filter the table to only look at the current campaign and then take the minimum of the chosen start dates. Like this:
So creating table visual and inputting the budget owner, the campaign number and then the measure above results in the following:
And for the end date, a similar measure is just created calculating the maximum instead.
Hope this helps.
Best regards
Thanks, the problem is that I need to pass those date to a visual that accept them just if they are from the same table.
So I created a New table using
Summary = SUMMARIZE(Weekly,Weekly[Budget Owner],Weekly[Campaign],)To have the unique combination of Budget Owner and Campaigns but I do not know how to add the Columns including calculation of mix and max for Start and End Date
Thanks
Hi again
Not perfectly sure what you're asking for and what you want to achieve. You should be able to use the columns you already have along with the new measures in any visual to achieve something like I showed in the table-screenshot. This could be done without creating a new table with SUMMARIZE.
But if you can explain more in detail what you want to achieve?
Best regards.
