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
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
Helper IIIHow 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?