Forum Discussion
Conditional expression for PRODUCTX
I had a measure which shows the number of remaining customers for each month, after counting for the predicted churn. CALCULATE(
PRODUCTX('Year Month', 1-[Churn% Last Year]),
FILTER(
...
Anonymous , can you share formula of
[Churn% This Year], [Churn% Last Year]
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I have a `Churn% old users` column in the `Year Month` table. So the measures retrieve the info from that column
```
Churn% This Year =
SELECTEDVALUE('Year Month'[Churn% old users])
```
```
Churn% Last Year =
var _ret = CALCULATE(
MAX('Year Month'[Churn% old users]),
FILTER(ALL('Year Month'),
SELECTEDVALUE('Year Month'[År Måned LY]) = 'Year Month'[År Måned]))
//LY column is the previous year
return
IF('Prosent Endring i Churn (gamle)'[Prosent Endring i Churn (gamle) Value] = 0,
_ret,
_ret*(1+'Prosent Endring i Churn (gamle)'[Prosent Endring i Churn (gamle) Value]))
```