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

Proud to be a Super User!




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

 

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

Proud to be a Super User!




Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors