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.
- UKNSI-Powerbi2 years agoFrequent Visitor
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
- Anonymous2 years agoNot applicable
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.
- UKNSI-Powerbi2 years agoFrequent Visitor
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.