Forum Discussion
Solved
Summarize / Lookup Data
Hello everyone. I'm starting my studies at PowerBi, and I came up with a challenge that I can not solve. I need to summarize a table, grouping by a category, searching the first date of this cat...
Hi,
It follows again:
For the first date in the filter context:
CALCULATE(SUM(VALUE);FIRSTDATE(STARTDATE))
Regards,
Hi finan,
Try to do FIRSTDATE function.
https://msdn.microsoft.com/en-us/library/ee634806.aspx
It works with filter context.
I hope help you.
Best regards,