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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
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!

 #proudtobeasuperuser

2 REPLIES 2
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")?

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!

 #proudtobeasuperuser

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors