Visual KPIs for dynamic dates

[Syndicate_Admin]

Good morning everyone,
Thank you so much for reading the post, but after trying, I find myself looking for the solution.
I find a data table where there are DAY, MONTH AND YEAR and also Orders:
MONTH DAY YEAR Orders

JANUARY	15	2023	25
JANUARY	30	2023	52
FEBRUARY	15	2023	345
FEBRUARY	30	2023	58
MARCH	15	2023	245
MARCH	30	2023	56
APRIL	15	2023	745
APRIL	30	2023	587
MAY	15	2023	245
MAY	30	2023	2
JUNE	15	2023	5
JUNE	30	2023	525
JULY	15	2023	25
JULY	30	2023	6
AUGUST	15	2023	7
AUGUST	30	2023	142
SEPTEMBER	15	2023	5
SEPTEMBER	30	2023	56
OCTOBER	15	2023	96
OCTOBER	30	2023	45
NOVEMBER	15	2023	83
NOVEMBER	30	2023	555
DECEMBER	15	2023	77
DECEMBER	30	2023	4
JANUARY	15	2024	8
JANUARY	30	2024	55
FEBRUARY	15	2024	555
FEBRUARY	30	2024	861
MARCH	15	2024	64
MARCH	30	2024	59
APRIL	15	2024	245
APRIL	30	2024	52
MAY	15	2024	8
MAY	30	2024	7
JUNE	15	2024	77
JUNE	30	2024	52
JULY	15	2024	64
JULY	30	2024	5
AUGUST	15	2024	89
AUGUST	30	2024	35
SEPTEMBER	15	2024	235
SEPTEMBER	30	2024	41
OCTOBER	15	2024	255
OCTOBER	30	2024	58
NOVEMBER	15	2024	55
NOVEMBER	30	2024	6
DECEMBER	15	2024	66
DECEMBER	30	2024	48

Now I want to use the KPI chart with incremental decreases:

I want to get a measure that is dynamic, whether I select one day returns the current value, the selected one:

Whatever the trend axis is, as it changes, be it year, month or day.

And in the destination precisely the previous value.

That is, if I select a year, that it is the destination of the previous year, if I select a month, that it is the month of last year, and if I select a day that is the same day last year.

This is what I have tried for current value, but it changes everything at once.

Valor_Actual = 
VAR AnioSeleccionado = SELECTEDVALUE('MasterCalendar'[Year])
VAR MesSeleccionado = SELECTEDVALUE('MasterCalendar'[Month Number])  -- Asegúrate de que este campo contenga solo el número del mes (1-12)

RETURN
CALCULATE(
    COUNT('EncargosAnx'[encargos_id]),
    'EncargosAnx'[fecha] >= DATE(AnioSeleccionado, MesSeleccionado, 1) &&
    'EncargosAnx'[fecha] < EDATE(DATE(AnioSeleccionado, MesSeleccionado, 1), 1)  -- Para incluir hasta el último día del mes
)

I appreciate any help

[Anonymous]

Hi @migueldfr 

Did _AAndrade 's method solve your problem? If yes, could you please mark it as solution? This will help more users who are facing the same or similar difficulties. Thank you!

If you still have questions, please feel free to ask me.

Best Regards,
Yulia Xu

[Syndicate_Admin · Accepted solution]

Hi @migueldfr,

I'm attaching one pbix file with my solution.
I hope this could help you.

[migueldfr]

thnak you so much @Syndicate_Admin 

Such a great approach and wonderful way to sove this problem

I really appreaciate it

[Anonymous]

Hi @Syndicate_Admin 

Thank you for your sharing.

Best Regards,
Yulia Xu