Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cumulative Query Summary - Is it possible?

Good Morning Power BI Community,   I have a business need that I am looking to fill and was wondering if this is possible in Power BI & Power Query.   Basically I have a query that is run  on a d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Maybe I should explain that the transactions recived from the query are going to change every day and I want to save a daily summary of those transactions past the point where they would be retrieved from the database.

 

Essentially a table that is accumulating the history over successive daily refreshes.

Bohumil_Uhrin's avatar
Bohumil_Uhrin
Helper II
5 years ago

Anonymous, ok, altough I dont understand exact steps how you do it, the group function should do the job (if you dont have date column in the first table, you should group only by customers)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Bohumil_Uhrin  Yes, I agree Group By would be the way to go with the summary portion. Thank you.

    • Icey's avatar
      Icey
      Community Support
      5 years ago

      Hi Anonymous ,

       

      Is this problem solved?

       

      If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

       

      If not, please let me know.

       

       

      Best Regards,

      Icey

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Icey  Not solved yet. The real question is how to store cumulative summary of past queries in the data model somehow. I will try some ideas to do this.