Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
The following is a sample of my dataset and I would like to derive how much time I have worked each day.
In the above data, note that the 3rd column is an incremental value.
I'm able to create a report that shows incremental data everyday but what I'm looking for is to show data that I logged each day. Like:
Please advise.
HI @Anonymous ,
Based on your sample data,
Here is the measure you can use:
Hrs total for Task = CALCULATE(SUM('Table (2)'[Hrs]), ALLSELECTED('Table (2)'[Task]))
Let me know if this works.
Thanks,
Tejaswi
It's still the same, here's the output:
Hi @Anonymous ,
Can you be more specific with your requriements?
How did you get this data from your sample data? ( what is the calculation you are using to get this?)
Thanks,
Tejaswi
Hi @Anonymous ,
My requirement is to report data like this, and need help!
As you see in my previous post, I'm only able to get accumulated data (7, 11 and 14).
Thanks!
Hi @Anonymous ,
Create a new index columns thru edit queries
Add these two DAX columns and give a try.
1. to get the sum by by dates
Total Hours bY category = SUMX(FILTER(ALL('Table (2)'),[Date]=EARLIER('Table (2)'[Date])),[Hrs])
2. Subtract from preious row.
Column 3 = VAR Index = 'Table (2)'[Index] VAR Reference = 'Table (2)'[Task] VAR Prevhrs = CALCULATE ( FIRSTNONBLANK ( 'Table (2)'[Total Hours bY category], TRUE () ), FILTER ( 'Table (2)', 'Table (2)'[Index] = Index - 1 && 'Table (2)'[Task] = Reference ) ) RETURN IF ( ISBLANK ( Prevhrs ), 'Table (2)'[Total Hours bY category], 'Table (2)'[Total Hours bY category] - Prevhrs )
Thanks,
Tejaswi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |