Forum Discussion
sabilahmed
Resolver I
4 years agoComplex DAX: Contracted and Uncontracted Revenue - single Row value across multiple months (Help!)
Hello all, HELP ME! 😞 I am stuck on a problem that I can't get me head around and need the help of a super Power BI guru. I have an example table below. In my model it is called Agreemen...
- 4 years ago
Hello,
This issue has now been resolved. I used a CROSSJOIN between revenue contracts table and Calendar table. I then used SUMMARIZE to group the rows per month per year OR per StartofMonth date.
See below:
Thanks for getting back to me though.
sabilahmed
Resolver I
4 years agoamitchandak Hi Amit, sorry to approach you like this, is it possible you can help me with this? Cheers 🙂