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 have a Calendar table and I want to add current week in a month, number of weeks in a month columns to my Calendar table.
My week starts on a Tuesday. How do I achieve that?
Thanks.
Hi @bml123 ,
Please refer to my pbix file to see if it helps you.
Create a column.
Column =
CALCULATE (
DISTINCTCOUNT ( 'table'[WEE] ),
FILTER (
'table',
'table'[Co_year] = EARLIER ( 'table'[Co_year] )
&& 'table'[_month] = EARLIER ( 'table'[_month] )
)
)
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
weekinmonth = 1 + WEEKNUM ( 'Calenda'[Date] )-WEEKNUM( STARTOFMONTH ('Calenda'[Dat]))
currentWeek = Max(weekinmonth)
// Make two calculated columns
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |