Forum Discussion
Solved
Aggregation Rollup with Max date
My current Power BI report is presenting the result as it appears in the first table, but what I want to achieve is the table below that. I want it to rollup based on the Security ID and giv...
Hi Soulbroda
instead of adding the Trade Date to the report as column you can add it as a measure
MIN ( TableName[Trade Date] )
Instead od adding the Units - Trans Level to the report as column you can add it as a measure
SUM ( TableName[Units - Trans Level] )
Worked like a charm! Thank you so much! I only applied the fix to the Trade date and that did the magic.
