Forum Discussion
Creating Revenue Measure using 2 Fact Tables (Different Granularities)
Hi All, Hoping to get some advise on developing the correct measure which returns the revenue for records which match a critiera. The specifics 2 Fact tables at for different graunulari...
We've gone down this approach prodominatly because there needs to be an "As At" view for the business on both granularities. i.e. what was the record as at 1st of december 2023 vs current view.
how come on the challenge?
You can't have partially won opportunities.
The as of reports are done differently, via the event list. Possible in Power BI but better done upstream.
No you can't but you can have instances where we've won some parts of an opportunity but not others, which is where the product stage comes into play.
Based on what you've seen of the mock model do you think its not possible to achieve the orignal requirements?