The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
56 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |