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...
Thanks ryan_mayu
I think your sort will not work . once you have mutiple years
I am trying to get something like below . Please note my FY starts in Jul so calender month 7 = 1 and so on
| SorT FY | SorT Cal | |
| july - Aug | 1 | 4 |
| sep - oct | 2 | 5 |
| nov - dec | 3 | 6 |
| jan - feb | 4 | 1 |
| march - april | 5 | 2 |
| may - jun | 6 | 3 |
ryan_mayu
Super User
Super Userif you want to display the data in different years, you can add the year in the column
sort = if(ISODD(MONTH('Table'[Date])),year('Table'[Date])&month('Table'[Date]),year('Table'[Date])&month(EDATE('Table'[Date],-1)))
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_resultBi monthly Sort CAL =Var _result = if(dimDate[Calendar MonthNumber]+1 =1 , 1 ,QUOTIENT(dimDate[Calendar MonthNumber]+1,2))return_result- ryan_mayu
usually 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