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 all,
I have a matrix where the totals are not working correctly and need your expertise. What I am doing is for a time report. We have the user name as the row, the charge code where the time is charged as the column, and then the total hours as the values. But it is listing the total hours that have been entered since the start of time, and not just the past month.
Can anyone help with the DAX formula? Thanks
Is showing up as:
But for Jean should be:
Solved! Go to Solution.
Hi @cedmiston ,
I suggest you use the following measure:
Measure =
CALCULATE (
SUM ( 'Table'[Duration] ),
FILTER (
'Table',
'Table'[Date]
>= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 )
&& 'Table'[Date] < DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
)
)
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared?
For more details, please refer to the sample pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EU0LMfVjhtpDj7WQ42...
Best Regards,
Dedmon Dai
Hi @cedmiston ,
I suggest you use the following measure:
Measure =
CALCULATE (
SUM ( 'Table'[Duration] ),
FILTER (
'Table',
'Table'[Date]
>= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 )
&& 'Table'[Date] < DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
)
)
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared?
For more details, please refer to the sample pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EU0LMfVjhtpDj7WQ42...
Best Regards,
Dedmon Dai
Yes this worked thank you! Forgot to mark as solution.
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |