Forum Discussion
Total not summing properly
Hello. I have created a measure that calculates the sales for new customers for fiscal prior year last full month, Fiscal February fiscal year 2021. The ParentMinDate is the date the customer had the...
Hi Ben, yes I have tried to replace the VAR with actual dates and Iget the same total. The calc for [InvoicedSalesCohort] is jsut the sum of a column. I get the same total when I put in the sum(Cohort[Sales]) instead of [InvoicedSalesCohort].
InvoicedSalesCohort:=
CALCULATE(
sum(Cohort[Sales]),
Cohort[is_revenue_ind]=1
)
I think it has something to do with the flags for fiscal period.
What appears in the total when you change measure to...
SalesCohortPyfm =
VARStartDate=CALCULATE(MIN('Calendar'[calendar_date]),FiscalIndicators[is_pyfm_ind]=1)
VAREndDate=CALCULATE(MAX('Calendar'[calendar_date]),FiscalIndicators[is_pyfm_ind]=1)
Return
StartDate
Actually can you share a picture of your model. Specifically how your calendar and FiscalIndicstors is related.
Sure its joined by calendar date.
Can you talk me through
is_pyfm_ind ... how many months have that as 1?
It looks to me like on the total row you're returning the full range of dates from your calendar table rather than just a months worth..