If formula

[Anonymous]

Hello all,

I'm looking to write a formula that will give me the current week we are in and have the start of the week be Monday. For example, 5/18/2020, 5/25/2020, 6/1/2020.

So the formula would go If(table [column1])=Condition, Current Monday of the week, table [column1])

Any help would be awesome!

Thank you!

[AlB]

Hi @Anonymous 

If you have dates in a column, Table1[Date], you can have the Monday of that week in another column with:

Monday Col = Table1[Date] - (WEEKDAY(Table1[Date],2) - 1)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

@Anonymous 

If you are looking for the Monday of the current week just use TODAY()

TODAY() - (WEEKDAY(TODAY() ,2) - 1)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

What if I don't have a dates in another column?

[az38 · Accepted solution]

@Anonymous 

if you need exactly current week Monday try

If(
table[column1])=Condition, 
TODAY() – WEEKDAY(TODAY(),2) + 1, 
table[column1]
)

[az38]

Hi @Anonymous 

try

If(table [column1])=Condition, 
Table[Date] – WEEKDAY(Table[Date],2) + 1, 
table [column1])