Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
return list
Solved! Go to Solution.
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.
Hi, @XaviOV
According to your IF formula, I can’t clearly understand what you want to get. I’m wondering what does “LETRA[i]” mean? Because the column [LETRA] is “Text” type and it can’t be used to calculate with a number. Would you like to add a column to display your expected result manually?
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.
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 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@XaviOV , Still not clear. You create first column using generateseries , rest need to come from that
generateseries(1,5)
https://docs.microsoft.com/en-us/dax/generateseries-function
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |