Forum Discussion
Helper IHelp 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
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/
2 Replies
- tackytechtom
Most Valuable Professional
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/ 
fbostan1Awesome! 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")?