Forum Discussion
Help me stop my value increasing every year.
I need help the Total Capacity. I want it to stay 124 no mater the year. for some reason it keeps adding the total slots to every year. so for more infromation a provider has the Total Capacity at the time of an Agreement we requested they grow the total slots. and i i cant see if they are meeting this request as the Total Capacity Requested keeps growing when their Total Capacity incareses. I dont want that. I just want the Total Capacity requested to show the Total Capacity at the time of the Agreement. and never change no mater what year it is.
so that way when u use this i can see if they meet thier goal
thank you in advance
I was able to fix it by rewritng it the way below.
6 Replies
I was able to fix it by rewritng it the way below.
Hi 08Tedz40
First of all, thanks for the reply from lbendlin.
It seems that you have gotten a solution. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data 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.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523hope my reply below helps
- lbendlin
no, it does not help.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data 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.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
This is the data for the 124 shown above I have a rolling calander that creates a relationship to the date of Agreement on the Grant entites table and to report month on the master provider table
