topic Re: HELP!!! calculating LOST CUSTOMERS in DAX Commands and Tips

HELP!!! calculating LOST CUSTOMERS

APIR — Mon, 24 Jun 2024 21:39:39 GMT

HI friends,

I am creating a customer lost calculation and I'm able to calculate it in the subtotals correctly but unable to place it in the row level as the customer does not appear that month. I show you:

Also I would like to calculate the money that the customer 493 spent in the past month. But appearing in february in it's new line.

Please fins attached the PBI file HERE

https://drive.google.com/file/d/13Bdh978nHmrAZWro06cOMaQ2J4ggTV0e/view?usp=sharing

Thank you very much!!!

Re: HELP!!! calculating LOST CUSTOMERS

APIR — Mon, 24 Jun 2024 23:33:43 GMT

Solved. If someone is interested, here goes the solution:

https://drive.google.com/file/d/1NxMnjVm41XyiNfkgbL8rzrjhl-W2HGtP/view?usp=sharing

Br!

Re: HELP!!! calculating LOST CUSTOMERS

Anonymous — Tue, 25 Jun 2024 00:55:27 GMT

Hi APIR ,

I am glad you have solved the problem. Please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu