Forum Discussion
Calendar 13-24 months
Hi,
I am looking to create a column in a calendar for a report that will generate an integer of 1-12 for months in year 1, 13-24 in year 2 and 25-26 in year 3. The"MONTH" function is only 1-12 so it clearly needs a bit more than this.
Any advice would be much appreciated.
Hi Anonymous ,
I have created a simple sample, please refer to my pbix file to see if it helps you.
Create a table.
Then rankx it.
Finally create a measure.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
I have created a simple sample, please refer to my pbix file to see if it helps you.
Create a table.
Then rankx it.
Finally create a measure.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.