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.
Hello All,
I am trying to find a formula that will tell me how many days in the week have passed.
For example:
Week is Sunday to Saturday
Today is Tuesday
I need a formula that will returnt the number 2 (for two days have passed).
Thank you!
Solved! Go to Solution.
This is probably the most complicated way of doing this but here it is how I determined how many days have passed:
Var
CurrentDate = Today()
Return
WEEKDAY(CurrentDate)-1
This gave me a numerical value in which I used to calculate the average daily production quantity by taking week to date production quanity and dividing it by the days that have passed.
I've had issues with refreshes on our company's internal report server when I only use the 2nd half of that formula so I've started to establish the current date using the Var code and haven't had issues since.
Nevermind, I figured this out.
Thanks!
Please post solution if you are able, someone else might have this question. I can think of a few ways of doing this.
This is probably the most complicated way of doing this but here it is how I determined how many days have passed:
Var
CurrentDate = Today()
Return
WEEKDAY(CurrentDate)-1
This gave me a numerical value in which I used to calculate the average daily production quantity by taking week to date production quanity and dividing it by the days that have passed.
I've had issues with refreshes on our company's internal report server when I only use the 2nd half of that formula so I've started to establish the current date using the Var code and haven't had issues since.
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 |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
65 |