Measure or column for calculating confirmed revenue

[richrich123]

Hi all,

I wonder if anyone could help / advise on this.

Im trying to show a chart that visualises confirmed revenue by month v revenue at risk. Confirmed revenue is commited revenue when a customer is in contract v at risk which is from the end date of the contract (and dependant if they renew or not). My model has a calender table and the order table.

To try and be clear, please see image which shows the 4 values (green) held in the order table and then the months and values that would need to be worked out (orange) in order to see what I need.

The chart added below (Excel) shows a good representation of blue (confirmed contracted revenue) and whats at risk (orange) as out of contract.

I just need to do that in PBI and not Excel 🙂

[v-yingjl]

Hi @richrich123 ,

In your picture, seems not to distinguish the logic between confirmed revenue and at risk revenue, what are the criteria to distinguish them? Could you please consider provide more details about it for further discussion?

Best Regards,

Yingjie Li

[Daviejoe]

Hi @richrich123 

You would either need to have a field that had listed income as "confirmed" or "at risk" or use the date of contract end to identify when a contract ends.

Either way, I think you will need a calculated column to determine whether the income for the month is "confirmed" or "at risk".