Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I get it. Ive done all these calcs. That is the right date range. I dont get it. 🙂

 

 

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Ok next...

1) What relationship exists between calendar and Cohort?


2) If you go into the data table view and filter on ParentMinDate to the correct month can you see just the expected numbers. 

3) Are you able to run performance analyser in power bi and get the query generated by the table visual.

 

Think I might have to mock something up locally but am away from a laptop until Sunday evening (uk).

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    ParentMinDate-CALCULATE( min(Cohort[local_transaction_date]), ALLEXCEPT(cohort,Cohort[ParentPartnerID]))

    Cohort is joined ot Partner table (customer) by Partner_sk=partner_sk
    Cohort is joined to calendar by Calendar_date =  calendar_date

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Also its important to note that I have another measure just like that one but its calculating the current year prior month and the total works great. Its using an indicator just like the other one.

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    What happens to both measures if you set the relationship between calendar and cohort as inactive?