Forum Discussion
amaniramahi
Helper V
Helper VDATESBETWEEN with ALL Function
I need to calculate Year Over Year results for the same periods I used the following code YOY% =
var UptoDate = MAX('Monthly Reg Data'[Sales Month])
var CY = Year(UptoDate)
var PY = C...
Sorry, It was my mistake
I figured it out
parry2k
Super User
Super Useramaniramahi for any time intelligence add date dimension in your model and then perform all-time intelligence calculation from that table and that is the issue with your measure. You can add date dimension using my blog post.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡