Calculate Days Since Last Purchase Using DAX In Power BI



How to Calculate “Total” for the number of days as its given incorrect results;

            ISBLANK([Date of Last Purchase]) || VALUE([Date Selected] - [Date of Last Purchase]) <= 0, BLANK(),
            VALUE([Date Selected] - [Date of Last Purchase])

As usual, looking forward for your help and support.




I’ve had a quick review of the tutorial and struggling to understand what the total of all these days actually offers.

I think the reason I didn’t worry to much about the total is because I felt it was meaningless in this instance.

What insight does the total actually offer to you here…Just summing up days on a per customer basis doesn’t really mean much don’t you think?