Forum Discussion

JMuthee's avatar
JMuthee
Regular Visitor
4 years ago
Solved

Bimonthly Reporting

Hieveryone, My first ask!  How to combine bimonthly reporting (e.g. report January-February; March-April etc) and can this be created into hierachy - January -June ?  Thanks in advance!
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    JMuthee , Create a new column in date table

     

    Bi Period = quotient(Month([Date])-1,2)+1

     

    Bi Period Year = year([Date]) *100 + quotient(Month([Date])-1,2)+1

     

    Create a rank for time intelligence

    Bi Period YearRank = rankx('Date',[Bi Period Year],,asc,dense)

     

    Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
    Custom Period till date: https://youtu.be/aU2aKbnHuWs

     

    Check if needed

    Half Year Time Intelligence, Half Year Till date: https://youtu.be/fkm3Xvjcpl0

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

JMuthee , Create a new column in date table

 

Bi Period = quotient(Month([Date])-1,2)+1

 

Bi Period Year = year([Date]) *100 + quotient(Month([Date])-1,2)+1

 

Create a rank for time intelligence

Bi Period YearRank = rankx('Date',[Bi Period Year],,asc,dense)

 

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs

 

Check if needed

Half Year Time Intelligence, Half Year Till date: https://youtu.be/fkm3Xvjcpl0