Forum Discussion

PowerBITestingG's avatar
PowerBITestingG
Icon for Resolver I rankResolver I
3 years ago
Solved

Calculate quantity for max date in snapshot table

I am trying to calculate the total quantity for the most recent date (12-Mar-23) I am using: Calculate(Quantity,snapshotdate = max(snapshot date) I have a snapshot table like this:   Snapshot...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    try this:

     

    test =
    VAR maxx2 =
        MAXX (
            FILTER (
                ALLSELECTED ( 'Table (7)' ),
                'Table (7)'[Snapshot Date]
            ),
            'Table (7)'[Snapshot Date]
        )
    RETURN
        if(ISBLANK(CALCULATE ( sum('Table (7)'[Quantity]),'Table (7)'[Snapshot Date] = maxx2 )),0,CALCULATE ( sum('Table (7)'[Quantity]),'Table (7)'[Snapshot Date] = maxx2 ))
     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi,

 

try this:

 

test =
VAR maxx2 =
    MAXX (
        FILTER (
            ALLSELECTED ( 'Table (7)' ),
            'Table (7)'[Snapshot Date]
        ),
        'Table (7)'[Snapshot Date]
    )
RETURN
    if(ISBLANK(CALCULATE ( sum('Table (7)'[Quantity]),'Table (7)'[Snapshot Date] = maxx2 )),0,CALCULATE ( sum('Table (7)'[Quantity]),'Table (7)'[Snapshot Date] = maxx2 ))
 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍