Forum Discussion
EARLIER Calculation in a Calculated table and column
Hello,
I was following the article https://pbidax.wordpress.com/2015/09/27/use-calculated-table-to-figure-out-monthly-subscriber-numbers/ 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:
Thanks for any help,
Tamir
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
2 Replies
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