EARLIER Calculation in a Calculated table and column

[Anonymous]

Hello,

I was following the article https://pbidax.wordpress.com/2015/09/27/use-calculated-table-to-figure-out-monthly-subscriber-number... step by step.

All went well until the last calculation that used the function EARLIER.

I get the wrong numbers and I cannot figure out why.

The calculation I refer to is the calculated column 'Monthly Joined and Left'[Subscribers]

Please see the file in the link:

MonthlySubscriberCountTamir

Thanks for any help,

Tamir

[v-shex-msft · Accepted solution]

HI @Anonymous,

I found this issue is caused with blank records, I test both your file and the sample file but can't found out why these records only generated on you side.

Maybe you can try to add condition to remove these blank records, after this steps, your formula works well.

MonthlyJoinedAndLeft = FILTER(SUMMARIZECOLUMNS(MonthlyJoined[MonthJoined], "CountJoined", SUM(MonthlyJoined[CountJoined]), "CountLeft", SUM(MonthlyLeft[CountLeft])),[MonthJoined]<>BLANK())

Regards,

XIaoxin Sheng

[Anonymous]

Hi @v-shex-msft

Your solution works like a charm 🙂

Thank you,

Tamir