Formula returning blank

[ben249]

Can anybody tell me why this formula is returning blanks? I would have expected the Year 1 Revenue column to return the Value column as it reaches the end of the formula without passing the first lot of criteria:

[Anonymous]

Hi @ben249 ,

There are many nested IF() statements in your syntax ,which make it hard to read. In this case,  I'd suggest you use SWITCH() instead.

In addition, please provide some dummy data and the logic of conditions in Text format to help us clarify your scenario.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

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

[pmay]

This DAX is not easy to read - I would suggest you format it first and upload again, then it will be easier for us (and you) to see which IF's are related and where they end.

Use this link:

https://www.daxformatter.com/

[ben249]

Hi @pmay , thanks for the response

Hopefully this is a bit clearer