Forum Discussion

UKNSI-Powerbi's avatar
UKNSI-Powerbi
Frequent Visitor
2 years ago

Paginate Report lookup

Hi,   I need some help about using index on a Microsoft Paginated Report. I already applied conditional formatting for the value in line (red if the value is below zero) but I cannot find a solutio...
Need Help
UKNSI-Powerbi's avatar
UKNSI-Powerbi
Frequent Visitor
2 years ago

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

 

 

  • UKNSI-Powerbi's avatar
    UKNSI-Powerbi
    Frequent Visitor
    2 years ago

    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.