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,
It follows again:
For the first date in the filter context:
CALCULATE(SUM(VALUE);FIRSTDATE(STARTDATE))
Regards,
Thyago_Rezende Amazing...
I got it.
One more question.
Can I make a column with a% of the total value?Example:
2017-09-10 % 0 Kbps~300Kbps 10,85138889 3,08% 300Kbps~600Kbps 39,34027778 11,18% 600Kbps~1Mbps 81,405 23,13% 1Mbps~2Mbps 220,3291667 62,61% 351,9258333 100% Good!!
you can use quick measures for get % of total.
https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
Best regards,
