Adding week number column to Date Dimension Table for specific rule.

Question

Hello,&nbsp;I am using the date dimensional table. In this table, I need DAX to define the week containing the 1st and the 7th day of the month as the 1st week. (For every month)Ex: Days -&gt; [1,7] = 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [8,14] = 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [15-21] = 3 ...Thank you for your help.

amitchandak · Accepted Answer

Anonymous , try a new column like 
&nbsp;
month week No = quotient(datediff([eomonth([date],-1)+1,[date],day),7)+1

Forum Discussion

Adding week number column to Date Dimension Table for specific rule.

2 Replies

Related content

Adding comments to specific row in table visual

degenerate dimensions

RLS on multiple dimensions

Adding columns

Specific matrix