Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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êsStarting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
60 | |
57 |