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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.