Forum Discussion
Weekday Last Year Comparison
Hi everybody ! I have a requeriment that i don't know how to achieve. Question is simple, how can I compare this year sales with exactly the same weekday sales of last year. take for instance, To...
Hi,
I want to know if your Tiempo[Fecha] is continuous date or not.
If it’s continuous date you can create a measure like below:
Measure yourMeasure = CALCULATE(SUM('Tiempo'[yourColumn]),SAMEPERIODLASTYEAR('Tiempo'[Fecha]))
When you use filter on this measure, remember to remove date hierarchy, just use date.
On the other way, if your Tiempo[Fecha] is not continuous date, there is not way to come to that result you want.
Best Regards
Alex