Forum Discussion
Solved
Count based on dates
Hi, I need to add some totals to a table based on dates. I have the following table ID. Cust. Date_sent Kevin. 20/08/2024 Barry. 20/08/2024 Louise 21/08/2024 What I n...
Hello, M_SBS_6 ,
given you want physical column, perhaps you can do it in DAX, even tho I would recommend having this as a measure.
the dim table:
lettervol = CALCULATE( COUNTROWS('fact'), DATESINPERIOD('calendar'[Date], dim[Date_sent],-6,MONTH) )fact:
Calendar is extra, I recommend having it as well.
Hello, M_SBS_6 ,
given you want physical column, perhaps you can do it in DAX, even tho I would recommend having this as a measure.
the dim table:
lettervol =
CALCULATE(
COUNTROWS('fact'),
DATESINPERIOD('calendar'[Date], dim[Date_sent],-6,MONTH)
)
fact:
Calendar is extra, I recommend having it as well.