Forum Discussion
Measure issue
Hi All, I have a matrix where rows are different cost types, the column has months from January to December, the values is the amount which is of two types either forecast or invoiced. Filters ap...
Anonymous
**If this post helps, please consider accept as solution to help other members find it more quickly.
Hi Mahesh,
Thanks again but I understand in my data some of the item types are blank because of which is it still considering 0 as green for the future years like 2023 & 2024. I tried both your solutions they din't work can you help me with a formula where if the item is blank and year is greater than 2023 it should be blue.
Thanks in advance 🙂