Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Osirusblue
New Member

Cumulative Data with Delta

Hello, I'm trying to build out some visuals from a query that returns work id, completed work, and date [weekly]. Word IDs can span multiple weeks. What I need is the first completed work amount per work id [earliest week value for that ID] and then against that same work ID for each subsequent week add only the delta to the first value. I'm sure there's a more logical way to get what I'm after but I'm so new at this whole thing. These individual IDs then group up into a separate Project level ID. So multiple IDs in this data set will have hour totals that connect.

Example:

Osirusblue_1-1713973976048.png

Osirusblue_2-1713974476080.png

 

In the visual I'd want a per week value not a total cumulative value, 12/2 would be 16, 12/9 would be 46 etc. against this massive 10k lines data set. Any help would be appreciated

1 REPLY 1
v-binbinyu-msft
Community Support
Community Support

Hi @Osirusblue ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

 

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.