Forum Discussion
Paginate Report lookup
You can consider to use iff() function , you can refer to the following link.
Solved: Conditional Formatting of Fields in Paginated Repo... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
Thanks for the hint about lookup, it's a good starting point.
I tried lookup but it's not clear how to use it as in my case I think (but I'm not sure) there's an array implication. In fact I need to lookup week + 3 to retrieve the value for a correct conditional formatting
Thanks
You can refer to the following link.
Solved: Sum Table Column of Lookup values - Paginated Repo... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tried but it doesn't work. I forgot to mention Net column is a measure. I really don't have idea how to achieve it.