Forum Discussion
Count Jobs within Dates Selected
Hi,
Ensure that you have a Calendar Table with calculated column formulas for year, Month name and Month number. Sort the Month name column by the Month number. Create a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table. to your visual, drag year and Month name from the Calendar Table. Write these measures
Date fo first interaction = calculate(min(Data[Transaction date]),datesbetween(calendar[date],minx(all(calendar),calendar[Date]),max(calendar[date])))
New customers = countrows(filter(values(data[customer code]),[Date fo first interaction]>=min(calendar[date])))
Drag the second measure to a card visual.
Hope this helps.
I think I follow what you said. I will give that a try and let you know if it works.