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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
fbostan1
Frequent Visitor

Help with Access Formula into PowerBI Dax

Hi,

 

I need help with this formula I have from Access which I want to convert it into PowerBI Dax.

Access formula =IIf(Weekday(Date()) Between 2 And 3,Date()-4,Date()-2) 

Numbers for weekdays Sunday =1 Monday =2 Tuesday =3 Wednesday=4 Thursday =5 Friday =6 Saturday =7

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @fbostan1 ,

 

Not sure about the Access syntax, but I'll give it a try:

TomsCalculatedColumn = 
IF ( WEEKDAY('date'[Dates] ) = 2 || WEEKDAY('date'[Dates] ) = 3, 'date'[Dates] -4, 'date'[Dates] -2 )

I assumed that "Date()" is a date column.

 

If "Date()" is a function for today's date, then you can use this one:

TomsMeasure = 
IF ( WEEKDAY(TODAY() ) = 2 || WEEKDAY(TODAY() ) = 3, TODAY() -4, TODAY() -2 )

 

Hope this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
fbostan1
Frequent Visitor

Awesome! worked perfectly, thank you so much!

I also need help with this, I want to write a Dax formula for

(If ORDR_DATE is between Rx Direct and Rx Direct End then "Y" else "N")?

fbostan1_0-1647545779303.png

 

tackytechtom
Super User
Super User

Hi @fbostan1 ,

 

Not sure about the Access syntax, but I'll give it a try:

TomsCalculatedColumn = 
IF ( WEEKDAY('date'[Dates] ) = 2 || WEEKDAY('date'[Dates] ) = 3, 'date'[Dates] -4, 'date'[Dates] -2 )

I assumed that "Date()" is a date column.

 

If "Date()" is a function for today's date, then you can use this one:

TomsMeasure = 
IF ( WEEKDAY(TODAY() ) = 2 || WEEKDAY(TODAY() ) = 3, TODAY() -4, TODAY() -2 )

 

Hope this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors