Forum Discussion
Formula returning blank
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...
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.