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,
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,