Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Count months without sales with dax

Hello I have the following situation. I want to count the months without sales to the date a seller has, from their start date. In my calendar table I have registered the date of entry of the selle...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Hello Friend, if it worked but tells me every month where there were no sales. The equivalent in excel would be COUNT. WHITE.

I think I did not formulate my question correctly. What I needed is to know how many months a customer has been without sales since their last sale. The answer was very simple, just use the DATEIFF function.

Thank you very much anyway.