Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hi all,
I need help in creating a loop.
I have this kind of a table:
I need to check what is the date (starting from today) when either the sum of the persons Daily_sum values from the previous 30 days is less than 3000 or the “Date 1” date is in the past? The result should be the date as a String and if neither happens in the next 14 days, then the result should be a String “next 14 days OK”.
I’m guessing a loop running 14 times is the only way to do this but I’ve never used one.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...