Forum Discussion
MIN/MAX Date Based on Column with Multiple Lines
Hi bmdailey,
Based on your description, I assume your resource sample data is the same. Because your sample table is shown in screenshot, I can't copy, so I typed some part of it for reference.
sample table
Then click "New Table" under Modeling on home page. Type the following formula and you will get the table below.NewTable = SUMMARIZE ( Test, Test[Department], Test[Release], "Budget", SUM ( Test[Budget] ), "Actual", SUM ( Test[Actual] ), "Variance", SUM ( Test[Variance] ), "Start Date", MIN ( Test[Start Date] ), "Finish Date", MAX ( Test[Finish Date] ) )
Finally, you can create a table visual, select all the columns to display as follows.
Best Regards,
Angelia
Erik, thanks for the suggestion. I believe I've tried this method and had an issue with repetitive lines (*opposed to the value roll up by Department, Release). It's been some time ago so I will give it a shot and let you what I find out.
Thanks again for the suggestion....results to follow
Byron
Microsoft EmployeeHi bmdailey,
Based on your description, I assume your resource sample data is the same. Because your sample table is shown in screenshot, I can't copy, so I typed some part of it for reference.
sample table
Then click "New Table" under Modeling on home page. Type the following formula and you will get the table below.
NewTable =
SUMMARIZE (
Test,
Test[Department],
Test[Release],
"Budget", SUM ( Test[Budget] ),
"Actual", SUM ( Test[Actual] ),
"Variance", SUM ( Test[Variance] ),
"Start Date", MIN ( Test[Start Date] ),
"Finish Date", MAX ( Test[Finish Date] )
)
Finally, you can create a table visual, select all the columns to display as follows.
Best Regards,
Angelia