Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Insert specific values if fields are empty

Hi Community, I have the following data table. It is filtered by article number = 1000. I selected the "Show elements without data" option, so I have every CalenderWeek displayed. As you can...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , A measure like this

if(max(Table[article]) =1000 , 600, [Stock])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you, but the values are still empty if i use this measure.

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I inserted sample output in my original post.

       

      Here are the excel sheet with 2 tables and my pbix. I hope you can open it.

      Filebin :: bin dny8k4wdj4jx4yb7