Forum Discussion
Bi monthly Date table
Hi Guys Has anyone ever create date table with Bi monthly view ? For eg Jan-Feb March-April etc and have these by fiscal view and calender view along with sort column ? What wil...
This is what i did to get what i wanted
Bi monthly Sort FY =
Var _result = if(dimDate[Fiscal MonthNumber]+1 =1 , 1 ,QUOTIENT(dimDate[Fiscal MonthNumber]+1,2))
return
_result
Bi monthly Sort CAL =
Var _result = if(dimDate[Calendar MonthNumber]+1 =1 , 1 ,QUOTIENT(dimDate[Calendar MonthNumber]+1,2))
return
_result
ryan_mayu
Super User
Super Userusually we should have different solutions. if this works, then you can use it.
Do u know if there is a norm / best practise for Bi monthly time scale ?
I dont want to use things which are not best practise / norm