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.
Is there a way to get all data in N weeks time from one column?
I have found Date.IsInNextNWeeks, however if I want the week after next (Next 2 weeks) I also get the next week. Which I don't want.
Filtering by the next N weeks then deleting all weeks up to N will be fine, but I'm not sure how to do it if its possible.
If anything needs clarifying please don't hesiate to ask, thanks in advance.
Solved! Go to Solution.
Your filter condition could be
Date.IsInNextNWeeks([DateCol], N) and not Date.IsInNextNWeeks([DateCol], N-1)
Alternatively, you could shift the date and check if it's in the next 1 week:
Date.IsInNextNWeeks(Date.AddWeeks([DateCol], N-1), 1)
Your filter condition could be
Date.IsInNextNWeeks([DateCol], N) and not Date.IsInNextNWeeks([DateCol], N-1)
Alternatively, you could shift the date and check if it's in the next 1 week:
Date.IsInNextNWeeks(Date.AddWeeks([DateCol], N-1), 1)
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |