Passing dynamic value to measure

[BrianJ]

@WendyZhang ,

FYI – we have some great free tools available for the creation of mock datasets, in addition to the masking techniques for your actual data file. Check out the thread below which provides links to all of them:

Prior Year Sales data FULL year when current year date selected

@cobrecht, Welcome to the forum - great to have you here! You will always get the best response/support on the forum if you provide not only a clear explanation of your issue, but a PBIX work in progress and a mockup of the results you want to see. If your data are sensitive, we have instructions for masking confidential info, as well as multiple free tools to create datasets and data models representative of your problem: [How To Mask Sensitive Data In Power BI] [How T…

– Brian