Forum Discussion
Splitting Collected Amounts between Current Year and Prior Years
Hi
I'm having trouble with a dax code of mine. As you can see from the screenshots below. One shows you collected amounts by year collected and by the year the bill is issued. Matrix works. However when I tried to created Dax measures for CY/PY Amounts. It's only going back 2 years. Not showing me data for 2021-2020-2019 as CY. (also screenshot attached). What's wrong?
1 Reply
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
