Dear,
i have dates table and i want with date slicer(between) on my page , i want to pass constant value(5000) to the first day of month only as per date selection from slicer.
data and slicer:
| Date |
| 01/01/2023 |
| 02/01/2023 |
| 03/01/2023 |
| 04/01/2023 |
| 05/01/2023 |
| 06/01/2023 |
| 07/01/2023 |
| 08/01/2023 |
| 09/01/2023 |
| 10/01/2023 |
| 11/01/2023 |
| 12/01/2023 |
| 13/01/2023 |
| 14/01/2023 |
| 15/01/2023 |
| 16/01/2023 |
| 17/01/2023 |
| 18/01/2023 |
| 19/01/2023 |
| 20/01/2023 |
| 21/01/2023 |
| 22/01/2023 |
| 23/01/2023 |
| 24/01/2023 |
| 25/01/2023 |
| 26/01/2023 |
| 27/01/2023 |
| 28/01/2023 |
| 29/01/2023 |
| 30/01/2023 |
| 31/01/2023 |
| 01/02/2023 |
| 02/02/2023 |
| 03/02/2023 |
| 04/02/2023 |
| 05/02/2023 |
| 06/02/2023 |
| 07/02/2023 |
| 08/02/2023 |
| 09/02/2023 |
| 10/02/2023 |
| 11/02/2023 |
| 12/02/2023 |
| 13/02/2023 |
| 14/02/2023 |
| 15/02/2023 |
| 16/02/2023 |
| 17/02/2023 |
| 18/02/2023 |
| 19/02/2023 |
| 20/02/2023 |
| 21/02/2023 |
| 22/02/2023 |
| 23/02/2023 |
| 24/02/2023 |
| 25/02/2023 |
| 26/02/2023 |
| 27/02/2023 |
| 28/02/2023 |
| 01/03/2023 |
| 02/03/2023 |
| 03/03/2023 |
| 04/03/2023 |
| 05/03/2023 |
| 06/03/2023 |
| 07/03/2023 |
| 08/03/2023 |
| 09/03/2023 |
| 10/03/2023 |
| 11/03/2023 |
| 12/03/2023 |
| 13/03/2023 |
| 14/03/2023 |
| 15/03/2023 |
| 16/03/2023 |
| 17/03/2023 |
| 18/03/2023 |
| 19/03/2023 |
| 20/03/2023 |
| 21/03/2023 |
| 22/03/2023 |
| 23/03/2023 |
| 24/03/2023 |
| 25/03/2023 |
| 26/03/2023 |
| 27/03/2023 |
| 28/03/2023 |
| 29/03/2023 |
| 30/03/2023 |
| 31/03/2023 |
| 01/04/2023 |
| 02/04/2023 |
| 03/04/2023 |
| 04/04/2023 |
| 05/04/2023 |
| 06/04/2023 |
| 07/04/2023 |
| 08/04/2023 |
| 09/04/2023 |
| 10/04/2023 |
| 11/04/2023 |
| 12/04/2023 |
| 13/04/2023 |
| 14/04/2023 |
| 15/04/2023 |
| 16/04/2023 |
| 17/04/2023 |
required result:
if i select date range 01/01/2023 to 04/03/2023
constant value will be only on 01/01/2023 and remain all blank like:
| Date | value |
| 01/01/2023 | 5000 |
| 02/01/2023 | |
| 03/01/2023 | |
| 04/01/2023 | |
and if i select date range 03/01/2023 to 04/03/2023
| Date | value |
| 01/01/2023 | |
| 02/01/2023 | |
| 03/01/2023 | 5000 |
| 04/01/2023 | |
| 05/01/2023 | |
| 06/01/2023 | |
| 07/01/2023 | |
and if i select date range 03/02/2023 to 04/03/2023
| 29/01/2023 | |
| 30/01/2023 | |
| 31/01/2023 | |
| 01/02/2023 | |
| 02/02/2023 | |
| 03/02/2023 | 5000 |
| 04/02/2023 | |
| 05/02/2023 | |
| 06/02/2023 | |
| 07/02/2023 | |
means constant value on minimum selected date only
how can i achieve this, could you please help ?
