Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

FirstNonBlank

Here's a firstnonblank() question again.    This was probably answered before however I cannot find the rigth answer in all the power bi blog.    I have three tables structured this way.    Pro...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    You may need to change the cross filter direction from "Single" to "Both" between Definition table to product definition, then your formula may work well

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, Anonymous 

You may need to change the cross filter direction from "Single" to "Both" between Definition table to product definition, then your formula may work well

 

Best Regards,

Lin