Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@Anonymous
if you need exactly current week Monday try
If(
table[column1])=Condition,
TODAY() – WEEKDAY(TODAY(),2) + 1,
table[column1]
)
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
@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
What if I don't have a dates in another column?
@Anonymous
if you need exactly current week Monday try
If(
table[column1])=Condition,
TODAY() – WEEKDAY(TODAY(),2) + 1,
table[column1]
)
Hi @Anonymous
try
If(table [column1])=Condition,
Table[Date] – WEEKDAY(Table[Date],2) + 1,
table [column1])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |