Forum Discussion

mbueno's avatar
mbueno
Frequent Visitor
4 years ago

Count measure with date intelligence

Hello guys, I've a question with count in measures.   I've a initial matrix as distinct count of client that bought on these months. Column: Date Row: ID Client   ID Client jan feb mar a...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mbueno , Add +0 and Try

metric_final = [measure_Sale_12M]-[measure_Sale_12M-1]+0

mbueno's avatar
mbueno
Frequent Visitor
4 years ago

Hey amitchandak, thank you for the answer but it didn't work ðŸ˜¥

metric_final = [measure_Sale_12M]-[measure_Sale_12M-1]+0

Before: 

After: 

And then when I filter with "metric_final is 0" on september ... show me this, doesn't counting