cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stijn977 Regular Visitor
Regular Visitor

Re: DAX Wizards - SUM of balance on oldest date before a given date.

Hi @Zubair_Muhammad this seems to work amazingly well! I managed to rebuild the solution and implement it in the final report, now i will have to manually do some double checks but for now I've marked it as the correct solution! 🙂 

The previous solution given was also correct, based on the requirements I had given. But your solution definitely is more complete and takes intoaccount new users! Amazing 🙂 Thank you for your help! 

stijn977 Regular Visitor
Regular Visitor

Re: DAX Wizards - SUM of balance on oldest date before a given date.

Thanks @Zubair_Muhammad

Getting a list of inactive id's is very useful. In my case there might be 1000s of inactive users / day ... so i wonder if it is possible to convert this into a count of inactive users instead of a (comma seperated) list? 

Super User III
Super User III

Re: DAX Wizards - SUM of balance on oldest date before a given date.

HI @stijn977

 

My apologies.I absolutely missed your question.

 

This would hopefully work

 

Count of Non Active Customers =
VAR Currentday =
    VALUES ( TableName[Date] )
RETURN
    IF (
        HASONEVALUE ( TableName[Date] ),
        COUNTROWS (
            EXCEPT (
                CALCULATETABLE ( VALUES ( TableName[User] ), TableName[Date] <= Currentday ),
                CALCULATETABLE ( VALUES ( TableName[User] ), TableName[Date] = Currentday )
            )
        )
    )
Try my new Power BI game Cross the River
stijn977 Regular Visitor
Regular Visitor

Re: DAX Wizards - SUM of balance on oldest date before a given date.

No problem, you've been an amazing help. I will test this out as soon as I can. Thanks again! 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors