Forum Discussion

reddevil's avatar
reddevil
Icon for Helper II rankHelper II
1 year ago
Solved

Select max value from the date slicer

Hello everyone, I have a date slicer which shows the Year, Quarters and Months as shown below:   Scenario: When I select Quarters or Months, I want the last value of the corresponding quart...
Need Help
  • reddevil's avatar
    reddevil
    1 year ago

    Hi Ashish

    Below is the data.


    Activity

    MonthYear

    Value

    Monthly Clients Churn

    Monday, 1 January 2024

    0.052

    Monthly Clients Churn

    Thursday, 1 February 2024

    0.022

    Monthly Clients Churn

    Friday, 1 March 2024

    0.0515

    Monthly Clients Churn

    Monday, 1 April 2024

    0.02255

    Monthly Clients Churn

    Wednesday, 1 May 2024

    0.022

    Monthly Clients Churn

    Saturday, 1 June 2024

    0.051

    Monthly Clients Churn

    Monday, 1 July 2024

    0.04

    Monthly Clients Churn

    Thursday, 1 August 2024

    0.051

    Monthly Clients Churn

    Sunday, 1 September 2024

    0.015

    Monthly Clients Churn

    Tuesday, 1 October 2024

    0.051

    Monthly Clients Churn

    Friday, 1 November 2024

    0

    Monthly Clients Churn

    Sunday, 1 December 2024

    0

    Monthly Clients Churn

    Wednesday, 1 January 2025

    0

    Monthly Clients Churn

    Saturday, 1 February 2025

    0

    Monthly Clients Churn

    Saturday, 1 March 2025

    0

    Monthly Clients Churn

    Tuesday, 1 April 2025

    0

    Monthly Clients Churn

    Thursday, 1 May 2025

    0

    Monthly Clients Churn

    Sunday, 1 June 2025

    0

       
     

    When Selected in Slicer as Q1 or just July, the data should be displayed for July, if selected for Q1, should display data for Sept2024

     

     

     
     

    Q1

    Jul-24

      

    Aug-24

      

    Sep-24

     

    Q2

    Oct-24

      

    Nov-24

      

    Dec-24

     

    Q3

    Mar-24

     

    Q4

    Jun-25

     

    Whole of 2024 as Year

    Jun-25

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Does this measure work?

=calculate(max(' PS NPS CSAT Lapses Data'[Value]),datesbetween('Datetable'[Date],max('Datetable'[Date]),max('Datetable'[Date])),' PS NPS CSAT Lapses Data'[Activity] = "Monthly Clients Churn")
reddevil's avatar
reddevil
Icon for Helper II rankHelper II
1 year ago

Hi Ashish

Thanks for replying, the above measure does not work as it doesnt filter the months and the value.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    You are welcome.  Why did you mark my reply as Answer then?  Share some data to work with, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

    • reddevil's avatar
      reddevil
      Icon for Helper II rankHelper II
      1 year ago
      apologies, i just thought it was reply 😞
    • reddevil's avatar
      reddevil
      Icon for Helper II rankHelper II
      1 year ago

      Hi Ashish

      Below is the data.


      Activity

      MonthYear

      Value

      Monthly Clients Churn

      Monday, 1 January 2024

      0.052

      Monthly Clients Churn

      Thursday, 1 February 2024

      0.022

      Monthly Clients Churn

      Friday, 1 March 2024

      0.0515

      Monthly Clients Churn

      Monday, 1 April 2024

      0.02255

      Monthly Clients Churn

      Wednesday, 1 May 2024

      0.022

      Monthly Clients Churn

      Saturday, 1 June 2024

      0.051

      Monthly Clients Churn

      Monday, 1 July 2024

      0.04

      Monthly Clients Churn

      Thursday, 1 August 2024

      0.051

      Monthly Clients Churn

      Sunday, 1 September 2024

      0.015

      Monthly Clients Churn

      Tuesday, 1 October 2024

      0.051

      Monthly Clients Churn

      Friday, 1 November 2024

      0

      Monthly Clients Churn

      Sunday, 1 December 2024

      0

      Monthly Clients Churn

      Wednesday, 1 January 2025

      0

      Monthly Clients Churn

      Saturday, 1 February 2025

      0

      Monthly Clients Churn

      Saturday, 1 March 2025

      0

      Monthly Clients Churn

      Tuesday, 1 April 2025

      0

      Monthly Clients Churn

      Thursday, 1 May 2025

      0

      Monthly Clients Churn

      Sunday, 1 June 2025

      0

         
       

      When Selected in Slicer as Q1 or just July, the data should be displayed for July, if selected for Q1, should display data for Sept2024

       

       

       
       

      Q1

      Jul-24

        

      Aug-24

        

      Sep-24

       

      Q2

      Oct-24

        

      Nov-24

        

      Dec-24

       

      Q3

      Mar-24

       

      Q4

      Jun-25

       

      Whole of 2024 as Year

      Jun-25