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.

XaviOV's avatar
XaviOV
Helper V
5 years ago

Hi amitchandak ,

There is a screen shot.


Regards,

 

Xavi

  • XaviOV's avatar
    XaviOV
    Helper V
    5 years ago

    Hi, amitchandak 

    I want transalate this formula to DAX

    list=[]

    i=1
    while i<5:

         if #pallets[i]<#huecos[i]:

             list=list+LETRA[i]

        i=i+1

    return list


    Regards,

    Xavi