While Loop in Power Query Editor

[Likhitha]

Hello All,

I have a Qlik Code below

date(mindate + IterNo() - 1) as DocDate
resident MinMaxDate while mindate + IterNo() - 1<=maxdate;

Here MinMaxDate is my Table name

It will generate a DocDate Column in a separate table using loop,How to do this in Power Query Editor??

Thanks in Advance.

[v-rzhou-msft]

Hi @Likhitha 

Do you want to build a Table named MinMaxDate in Power Query Editor only with DocDate Column (Date from mindate to maxdate) ?

I think you need to load the value of mindate and maxdate in your Qlik Code. 

Here I couldn't see the value of your mindate and maxdate.

For reference to while loop: Blog1, Blog2, Video

If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business.

And you can show me a screenshot of the result you want.

This will make it easier for me to understand your requirement.

Best Regards,

Rico Zhou

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

[amitchandak]

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

Not much idea on Qlik