Forum Discussion

Resolver I

4 years ago

Solved

Complex 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...

Need Help

sabilahmed
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:

https://community.powerbi.com/t5/Desktop/CROSSJOIN-to-obtain-one-row-per-month-between-start-and-end-date/m-p/2683027#M939531

Thanks for getting back to me though.

v-xiaotang

Community Support

4 years ago

Hi sabilahmed

Thanks for reaching out to us.

Can you share your sample files or sample data that fully covers your needs? Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

sabilahmed

Resolver I

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:

https://community.powerbi.com/t5/Desktop/CROSSJOIN-to-obtain-one-row-per-month-between-start-and-end-date/m-p/2683027#M939531

Thanks for getting back to me though.

Forum Discussion

Complex DAX: Contracted and Uncontracted Revenue - single Row value across multiple months (Help!)

Related content

Splitting contract amount over multiple years and months

All items from contracts where the contracts contain a certain item on them that I lookup.

Calculating Values By Contract By Country From Multiple Tables

MULTIPLE CARD

Forecasting Overspend on contract