Forum Discussion
Solved
Using DATESBETWEEN and FILTER
Hi, I have two unrelated tables: Fuel Purchases Days Worked The Fuel Purchases table records the date a vehicle refuled as well as the date it was previously refuled. The table Days Worke...
Hi,
did you create the column or measure ?
I did the column and it worked.
Appreciate your Kudos
Hi,
This calculated column formula works
Column = CALCULATE(COUNT('Days Worked'[Date]),FILTER('Days Worked','Days Worked'[Vehicle Registration]=EARLIER('Fuel Purchases'[Vehicle Registration])&&'Days Worked'[Date]>=EARLIER('Fuel Purchases'[Last Fuel Purchase Date])&&'Days Worked'[Date]<=EARLIER('Fuel Purchases'[Fuel Purchase Date])&&'Days Worked'[Has the vehicle worked today?]=TRUE()))Hope this helps.
Hi,
did you create the column or measure ?
I did the column and it worked.
Appreciate your Kudos
Yes, using a Calclulated Column instead of a Measure worked great.