Forum Discussion
How do deal with a while loop in Power Bi?
Hi All, My SQL query contains two dynamic values columns as well as a while loop condition. The two columns will be updated based on the While loop condition. I need to create a table in Power B...
amitchandakThank you for responding. thank you very much..........!😊
You can see an example of the query's output for five years' of data here. I need to display 20 years' of data starting from this date WHILE YEAR(@accEnd) >= YEAR(GETDATE()) -20.