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
2 years ago

Hello good day community,

I want to make a measurement with dax, which tells me the months where there were only sales, this measurement will help me to calculate the average sales in those months that there were sales, or if there was a direct way to take the average sales only from those months in which there was a sale.

Thank you.

Regards, Best regards.