Forum Discussion

tylesftw's avatar
tylesftw
Icon for Helper II rankHelper II
6 years ago

Cumulative Sales - Getting the Sales Line to Stop

Hi All,   I've been given a dataset that has both Sales & Forecast in one dataset. This means that the below code does not work as it extends out the sales line to match the FY2020 months. Without ...
Need Help
Tips and Tricks
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

You could add another IF() in your return such that if the MIN('Date'[Date]) is greater than your lastsalesdate variable to return blank(), otherwise your calculation.

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

tylesftw's avatar
tylesftw
Icon for Helper II rankHelper II
6 years ago

hmmmm 😞