Forum Discussion
Past 30 days calculation
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...
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])