Forum Discussion

XaviOV's avatar
XaviOV
Helper V
5 years ago
Solved

Generate a loop

Good morning,   I want to generate a loop like this with the following information:     list=[] i=1 while i<5:      if #pallets[i]<#huecos[i]:          list=list+LETRA[i]     i=i+1 r...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, XaviOV 

    According to your follow-up, I can understand your logic now, I think you can achieve this using the calculated table in Power BI, you can try my step:

    Go to the table tool, create a new table like this:

    List =

SELECTCOLUMNS(

    FILTER(ALL('Table'),[#pallets]<[#huecos]),

    "LETRA",[LETRA])

     

    Then you can get the expected list:

    The list will also be updated with the change of the dataset.

    You can download my test pbix file here

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

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

  • XaviOV's avatar
    XaviOV
    Helper V
    5 years ago

    Hi amitchandak ,

    There is a screen shot.


    Regards,

     

    Xavi