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.
Hi,
I am trying to replicate a SQL do while loop.
I have a table with customers some are active some are inactive and I need to get the figures for each month end using the created and terminated dates.
In SQL I would set up a loop to do my calculation and add one month to the date in the loop to add the data to a temp table.
E.G. the example code would be if Customer was created prior to the month end and the termonation date is blank or greater than the month they where active at the month end so include in the new table.
I have am having difficulty setting this up in Power Query so that the data from the data from the customer table is added to a new table and with each loop the next months data is appended to the table and so on until teh max date is reached (the previous month end date).
I have looked at many eaxmples and they dont seem to do what I Need, if it can be done
Any help would be greatly appreciated
Solved! Go to Solution.
@Anonymous ,
You may check if the following post helps.
https://community.powerbi.com/t5/Desktop/Accumulate-sum-minus-abandoned/m-p/206947#M91174
@Anonymous ,
You may check if the following post helps.
https://community.powerbi.com/t5/Desktop/Accumulate-sum-minus-abandoned/m-p/206947#M91174
Thank you I'll take a look
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 |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
146 | |
106 | |
104 | |
89 | |
65 |