Forum Discussion

Oki's avatar
Oki
Helper I
3 years ago
Solved

Quarter Value based on Date Range Filter

Hi, i need some help with my issues, first i want to show a quarter target in card, based on date range filter  if the date range filter is :  1. 1/1/2023 - 3/31/2023 = it will show Q1 ta...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    Oki , You can try a measure like

     

    format(maxx(allselected(date), Date[Date]), "\QQ")

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Oki ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create a measure.

    Measure =
VAR _1 =
    MAXX ( ALLSELECTED ( 'Table' ), 'Table'[Date] )
RETURN
    IF ( MAX ( 'Table'[Date] ) = _1, MAX ( 'Table'[quanter] ), BLANK () )

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Oki ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure =
VAR _1 =
    MAXX ( ALLSELECTED ( 'Table' ), 'Table'[Date] )
RETURN
    IF ( MAX ( 'Table'[Date] ) = _1, MAX ( 'Table'[quanter] ), BLANK () )

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.