Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Don't count before starting date

Hello,   I try to count my lost customers and my visual looks like     where Lost = IF([Netamount_mon])=BLANK(),1,0) and year and month come from a date table. Since customer A first purc...
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    Works fine in may case: (right the table via dimDate)

     

     

    Can you post your data model please? 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your help. When I try your DAX I receive the same error 😞

 

My Date comes from a different Date Table. This is exactly where I struggle

I should mention that I tried it as a measure

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

You have to use the by VAR firstime the date column from "6_lost"
VAR currenttime you have to use the date column from "6_lost"