Forum Discussion

NickzNickz's avatar
NickzNickz
Icon for Helper IV rankHelper IV
3 years ago
Solved

Display data based on report date for recent quarter

Hi ...   I have below table:   How can I display data for the recent quarter based on the date report trending? For example, today is 28/7/2023 so my KPI card should display 13.43 for Desi...
DAX
Help
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    hi NickzNickz, I hope this helps you! Thank You!!

    CREATE COLUMN : 

    Quater =
     QUARTER('Table Qtr'[Date Report])


    CREATE MEASURE :

    Latest Qtr =
    CALCULATE (
        MAX ( 'Table Qtr'[Design Stage] ),
        'Table Qtr'[Quater] = QUARTER ( TODAY () )
        ,ALLSELECTED('Table Qtr')
    )

     

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

hi NickzNickz, I hope this helps you! Thank You!!

CREATE COLUMN : 

Quater =
 QUARTER('Table Qtr'[Date Report])


CREATE MEASURE :

Latest Qtr =
CALCULATE (
    MAX ( 'Table Qtr'[Design Stage] ),
    'Table Qtr'[Quater] = QUARTER ( TODAY () )
    ,ALLSELECTED('Table Qtr')
)

 

  • NickzNickz's avatar
    NickzNickz
    Icon for Helper IV rankHelper IV
    3 years ago

    Mahesh0016 ,

     

    I have followed your instruction ... Below is the result.

     

     

    The result is as expected ... 

    Thank you so much for your help  ... 👍