cancel
Showing results for
Search instead for
Did you mean:
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? Mark my post as a solution!

Proud to be a Super User!

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? Mark my post as a solution!

Proud to be a Super User!

## Helpful resources

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors