Forum Discussion
Hire Duration Row Count
Hi Everyone,
I have a column called 'Hire Days', this column shows me the amount of days stock has been on hire.
Data Example;
| Hire Days |
| 100 |
| 1 |
| 50 |
| 300 |
I want to create a few new measures which can show me the following
- Amount of rows that have been on hire less than 90 days old.
- Amount of rows that have been on hire greater than 90 days but less than 180 days old.
Many thanks,
Elliot
Anonymous , Try measures like
calculate(countrows(Table), filter(Table, Table[Hire Days] <=90))
calculate(countrows(Table), filter(Table, Table[Hire Days] >=90 && Table[Hire Days] <=180))
1 Reply
Anonymous , Try measures like
calculate(countrows(Table), filter(Table, Table[Hire Days] <=90))
calculate(countrows(Table), filter(Table, Table[Hire Days] >=90 && Table[Hire Days] <=180))