Forum Discussion
Select max value from the date slicer
- 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
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.