Forum Discussion
Need help on a Row level data Calculation
Hi Friends, I need some help with this calculation, Don't know how to make this work I have data in the following format Year Month Revenue MTD Revenue 2020 4 489,611 ...
Hi smartp121 ,
It should have nothing to do with TotalDirectRevenue. This error is mainly EARLIER('Projects’[Revenue Month]), Parameter is not the correct type.
You can see whether MTD_Revee uses a calculated column or a measure, because the EARLIER function cannot be used for measure, and an error will occur
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.