Forum Discussion

kkoc3karan's avatar
kkoc3karan
Frequent Visitor
2 years ago

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

if 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)))

kkoc3karan's avatar
kkoc3karan
Frequent Visitor
2 years ago

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's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    usually we should have different solutions. if this works, then you can use it.

    • kkoc3karan's avatar
      kkoc3karan
      Frequent Visitor
      2 years ago

      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