Power BI Exchange

Hi All,

Below is sample data, were I'm trying to achieve sum of previous day/date;


For e.g. on today's date i.e. if it's Jul'12, I should get a sum of previous date i.e. of Jul'11, which will be

$115,354

On tomorrow's date, I should get a sum of Jul'12 i.e.

$222,410

I tried with relative day filtering (in the last 1 day), but it is not giving a sum of today's date.

See below: for Card 1, I used below measure:

for Card 2 - I used Relative date. If I say in the last 1 day, i still get a blank and if we say in the last 2 days, so I get the appropriate value.


Please advise. Thanks! as always.

------------------------------
Prem Guru
------------------------------

Tente

Previous Day Amount =
VAR Var1 =
    MAXX (
        FILTER ( ALL ( Tracker[DATE] ), [DATE] < MAX ( Tracker[DATE] ) ),
        [DATE]
    )
RETURN
    CALCULATE ( SUM ( Tracker[AMOUNT] ), Tracker[DATE] = Var1 )​

------------------------------
Vilmar Santos
------------------------------

Original Message:
Sent: Jul 12, 2022 04:15 AM
From: Prem Guru
Subject: View previous date sum

Hi All,

Below is sample data, were I'm trying to achieve sum of previous day/date;


For e.g. on today's date i.e. if it's Jul'12, I should get a sum of previous date i.e. of Jul'11, which will be

$115,354

On tomorrow's date, I should get a sum of Jul'12 i.e.

$222,410

I tried with relative day filtering (in the last 1 day), but it is not giving a sum of today's date.

See below: for Card 1, I used below measure:

Previous Day Amount = CALCULATE(SUM(Tracker[Amount]),PREVIOUSDAY(Tracker[Date ])) - which is giving blank

for Card 2 - I used Relative date. If I say in the last 1 day, i still get a blank and if we say in the last 2 days, so I get the appropriate value.


Please advise. Thanks! as always.

------------------------------
Prem Guru
------------------------------

Hi Prem,
In your Calendar create column Rank, then create column Rank related and then just use filter.

I am tired to copy/paste same solution as last 2 weeks I did it already 3 time. Review forum, you'll find it.

Regards,

------------------------------
Adam Artur Boltryk
Business Analyst
------------------------------

Original Message:
Sent: Jul 12, 2022 04:15 AM
From: Prem Guru
Subject: View previous date sum

Hi All,

Below is sample data, were I'm trying to achieve sum of previous day/date;


For e.g. on today's date i.e. if it's Jul'12, I should get a sum of previous date i.e. of Jul'11, which will be

$115,354

On tomorrow's date, I should get a sum of Jul'12 i.e.

$222,410

I tried with relative day filtering (in the last 1 day), but it is not giving a sum of today's date.

See below: for Card 1, I used below measure:

Previous Day Amount = CALCULATE(SUM(Tracker[Amount]),PREVIOUSDAY(Tracker[Date ])) - which is giving blank

for Card 2 - I used Relative date. If I say in the last 1 day, i still get a blank and if we say in the last 2 days, so I get the appropriate value.


Please advise. Thanks! as always.

------------------------------
Prem Guru
------------------------------