Counting the Last 30 Days

Question

Hi All,&nbsp;I have created a DAX measure to calculate On Hire Scaffolds. The measure is shown below;&nbsp;Scaffolds On Hire = COUNT('Standing Scaffold Data'[ErCompleteDate]) - COUNT('Standing Scaffold Data'[Off Hire Date])&nbsp;This measure is taking the count of rows in the erect complete date column and minusing the row count of the off-hire date which is giving the number of scaffolds erected.&nbsp;&nbsp;I want to create a few new measures which can show me the following&nbsp;- Amount of On Hire Scaffolds that are less than 90 days old.- Amount of On Hire Scaffolds that are greater than 90 days but less than 180 days old.&nbsp;Can anyone help with this?&nbsp;Many thanks,&nbsp;E&nbsp;

greg_deckler · Accepted Answer

Anonymous&nbsp;Well, perhaps check out the DAX Time Intelligence functions.&nbsp;
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
&nbsp;
If none of that helps.&nbsp;Sorry, having trouble following, can you post sample data as text and expected output?Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

Forum Discussion

Counting the Last 30 Days

1 Reply

Related content

Counting nulls

Day Count Measure

Count Operating Days

Count per day

Count calls per day and week