The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a text column called 'Week Indicator' that I want to create based on date values between last week and this week.
If the date is in last week then value = 'Last Week'
If the date is in this week then value = 'This Week'
What is the best way to do this?
I can't seem to use the query Date.IsInPreviousWeek for some reasoonm in the column function..
Solved! Go to Solution.
Hi guys,
Thanks for thereplies.
Yes v-caliao-msft, you are correct there is no function to find date in current week which is pretty annoying.
That said, I turned to power query and just added a new column with those existing methods:
Date.IsInCurrentWeek
Date.IsInPreviousWeek
based on this thread: http://community.powerbi.com/t5/Desktop/Add-column-for-Last-Week-to-table/m-p/157463#M68286
@Anonymous,
In Power query, there is Date.IsInCurrentWeek functin that returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current week, as determined by the current date and time on the system.
To check if the date is in previous week, there is no such a function to achieve this directly. You need to return the week number and previous week number, and check if the week number=previous week number. We can use Date.WeekOfYear function in Power query to get the week number.
Regards,
Charlie Liao
Hi guys,
Thanks for thereplies.
Yes v-caliao-msft, you are correct there is no function to find date in current week which is pretty annoying.
That said, I turned to power query and just added a new column with those existing methods:
Date.IsInCurrentWeek
Date.IsInPreviousWeek
based on this thread: http://community.powerbi.com/t5/Desktop/Add-column-for-Last-Week-to-table/m-p/157463#M68286
hi @Anonymous
Have a look at this solution which should enable you to create the columns that you need.
You can then use the columns IsInCurrentWeek and IsInLastWeek
https://community.powerbi.com/t5/Desktop/Display-this-week-amp-this-month-data/m-p/11207#M2459
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
79 | |
72 | |
48 | |
39 |
User | Count |
---|---|
138 | |
108 | |
69 | |
64 | |
57 |