• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

End of Month Balance that doesnt change with date filter

KennedyNK

New Member
Hi All

I have a Power Bi dashboard that shows the cumulative actual Revenue amount and I want to bring in my revenue Forecast table which is based on contract roll off dates. My dashboard has a date filter that shows the revenue progression through the month. I want to show what the expected end of month balance is based on my revenue Forecast table however it keeps adjusting with my date filter throughout the month. Can someone help me with how I can stop the intra month movement but not the monthly movement.
 
Last edited:
You might use a calculate + all combo. Now without knowing the data model it is hard to tell which formula you actually need. If you can upload a small model with sanitized data, one of the other members having PowerBI installed could help you in a better way.
 
Back
Top