Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 will be the best way to do something like this
I have tried below and it works however i need wider community opinion
you solution is good. you can also try this
Proud to be a Super User!
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 |
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)))
Proud to be a Super User!
This is what i did to get what i wanted
usually we should have different solutions. if this works, then you can use it.
Proud to be a Super User!
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |