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 Design Stage and so on .... 

 

Regards,

NickzNickz

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')
    )

     

2 Replies

  • 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  ... 👍