Forum Discussion
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...
Hi Anonymous
This is relatively simple in PQ but... where is the date on the first table?? Can you post the full table including the data that needs to be processed?
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
The date in the second table is generated by power query and would represent the date the query was refreshed and the summary was posted to the cumulative table. I can get an invoice date in the first table though. Does that help?
Thanks,
Aaron