Forum Discussion

Budfudder's avatar
Budfudder
Helper IV
7 years ago

Comparing Estimate To Actual - Using Two Dates

We have a series of opportunities that represent possible deals, and each has an estimated value and an estimated close date. So at any time I can look at the open opportunities, their estimated valu...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Sample data would be very helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


That being said, take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

  • Budfudder's avatar
    Budfudder
    Helper IV
    7 years ago

    Thanks Greg. I'm looking at the two links you gave, and they will help. But I feel the biggest problem is being able to pick off the dates the user has input.

     

    How can I allow the user to select a date period and get from that selection the actual dates to use in DAX expressions?