Calculate Days Since Last Purchase Using DAX In Power BI


#1

#2

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

IF(
            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.

Regards

Adil


#3

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?