The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I need to add some totals to a table based on dates.
I have the following table
ID. Cust. Date_sent
What I need is another column to see how many letters have been sent out within 6 months post and including today from date_sent.
The other column fields needed would be resp_date (the 6 month period) and count of resp_ID
So my table would look something like
ID. Cust. Date_sent. Lettervol
Any idea what measure to use please?
Solved! Go to Solution.
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.