March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
I am trying to calculate hours worked in the past 30 days. The formula was working and pulling the correct numbers until a new month started. Now, it won't pull in any values. Here is the equation I am using:
Solved! Go to Solution.
Hi @Anonymous,
If you share some dummy data to test, it will help to test and modify your formula:
How to Get Your Question Answered Quickly
In addition, you can also take a look at Greg_Deckler's blog of use date function to manually define the calculation range instead of time intelligence functions:
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
Is there a way to do this but from a specific/ fixed date as apposed to 'Today'?
Hi @Anonymous,
If you share some dummy data to test, it will help to test and modify your formula:
How to Get Your Question Answered Quickly
In addition, you can also take a look at Greg_Deckler's blog of use date function to manually define the calculation range instead of time intelligence functions:
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
You should be able to do this like the following:
Hours Worked Past 30 days =
SUMX(FILTER('MS TimeCard',[Work Date] <= TODAY() & [Work Date] >= TODAY() - 30),'MS TimeCard'[Hours])
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |