Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear Tutors,
I am trying to sum all values up to last year yesterday ( 1/1/2016 ~ 4/2/2016) (when today is 4/3/2017)
For example
I hope PY Calc stops at 21,455, which is April 2nd value. So, I want 21,455 at April 5th as well.
My equation is
CY Calc = CALCULATE(SUM(Table[Sales], DATESYTD('Date'[Date]))/1000
PY Calc = CALCULATE([CY calc], SAMEPERIODLASTYEAR('Date'[Date].[date]))
Thanks in advance
Best Regards,
Jiin Son
Hi @jiinson,
>>I hope PY Calc stops at 21,455, which is April 2nd value. So, I want 21,455 at April 5th as well.
You can add filter to the calculate formula to limit the calculation range or directly add a date filter at visual level filter.
Regards,
Xiaoxin Sheng
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
88 | |
88 | |
74 | |
68 | |
57 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |