Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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 | |
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")?
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 | |
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |