Forum Discussion
Helper IIIYTD and LYTD calculation Issue
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
Helper IIIThank you for this! I am trying to create a YTD slicer that will allow me to flip between full year and YTD. Essentially I am thinking I would have one field for amount and one for Previous year amount using SAMEPERIODLASTYEAR. Then I would need a slicer so i can flip back and fourth. Could you assit with this?
Super UserHi ROCKYDO12 ,
Try the fields parameter feature. Update your version of Power BI Desktop if it isn't available.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
- ROCKYDO12
How would this work if I have 9 visuals showing full year amounts for current year and previous year? What fields do I need to use for the parameter? Is there an easier way of just adding a slicer?