Forum Discussion
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!
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/aU2aKbnHuWsCheck if needed
Half Year Time Intelligence, Half Year Till date: https://youtu.be/fkm3Xvjcpl0
1 Reply
- amitchandak
Super User
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/aU2aKbnHuWsCheck if needed
Half Year Time Intelligence, Half Year Till date: https://youtu.be/fkm3Xvjcpl0