Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lha
Helper I
Helper I

Calculating the number of days in week that have passed

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!

2 ACCEPTED SOLUTIONS
lha
Helper I
Helper I

Nevermind, I figured this out.

 

Thanks!

View solution in original post

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. 

 

View solution in original post

3 REPLIES 3
lha
Helper I
Helper I

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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. 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.