Forum Discussion

finan's avatar
finan
New Member
8 years ago
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...
Need Help
Tips and Tricks
  • Thyago_Rezende's avatar
    Thyago_Rezende
    8 years ago

    Hi,

    It follows again:

     

    For the first date in the filter context:

    CALCULATE(SUM(VALUE);FIRSTDATE(STARTDATE))

     

    Regards,

finan's avatar
finan
New Member
8 years ago

Thyago_Rezende 

 

I did, I changed the field display as % of grand total.

 

Thanks again.