Forum Discussion
ROCKYDO12
Helper III
Helper IIIYTD and LYTD calculation Issue
Hello, I am trying to create some KPI's and I am using the following calculations for CYTD Sales and LYTD Sales: CYTD Sales: CALCULATE(SUM('Sales Base'[Amount]),DATESYTD(('Calendar'[Date]),"3...
Hi ROCKYDO12 ,
Your measures should work. There are other peculiarities in your model that could be causing this. Please see this PBIX for you reference - https://drive.google.com/file/d/108pq_k-N8CPQt5hTsaZgU8rP9h4L2dKs/view?usp=sharing
Hi ROCKYDO12 ,
Your measures work fine after creating the relationship which was not in the file you attached.
https://drive.google.com/file/d/1kcxiM9q401vRiMzYKE6QMhMeUQBPa58x/view?usp=sharing
danextian
Super User
Super UserCan you share sanitized copy of your pbix? It is easier to figure it out that way.
ROCKYDO12Helper III
Helper III- Ashish_Mathur
Access Denied message.
- danextian
Please make this available to the public.
