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
Ashish_Mathur
Super User
Super UserHi,
I get an error when i click on that link.
ROCKYDO12Helper III
Helper III- Ashish_Mathur
I get this message when i try to open the file.
- ROCKYDO12
https://drive.google.com/file/d/1NaWj4zhunXFzZcXm15ZQQl7SzerYXaXk/view?usp=sharing
Can you try this? Not sure whats going on I apologize.