Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Syndicate_Admin
Administrator
Administrator

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 seller. Imagine that your income was in January 2023 and until April it has no sales.

It would take 4 months without sales.

This is what I need, obviously I have my measure of Total Sales in general.

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

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.

Syndicate_Admin
Administrator
Administrator

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.

onurbmiguel_
Super User
Super User

hello @Syndicate_Admin 

My suggestion : 

Measure = 
var _temp = 
    FILTER(
        ADDCOLUMNS(
            SUMMARIZE(
                'Calendar',
                'Calendar'[Month (Year)]
            ),
            "_total",Sales[Sales Amount]
        ),
        ISBLANK(Sales[Sales Amount])
    )
return 
COUNTROWS(_temp)

 note: you need to have a month year column in the calendar table !

 

Best regards

Bruno Costa | Impactful Individual

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.