Forum Discussion
Create Billing Periods
Hi Bosh ,
We can create a calculate column to meet your requirement.
Column = var _month =MONTH('Table'[Date]) var _next_month = _month + 1 var _current_date = DATE(YEAR('Table'[Date]),_month,26) var _next_date = DATE(YEAR('Table'[Date]),_next_month,25) var _format1 = FORMAT(_next_date,"mmm")&" "&YEAR('Table'[Date]) var _format2 = FORMAT(_current_date,"mmm")&" "&YEAR('Table'[Date]) return IF('Table'[Date]<_next_date && 'Table'[Date]>=_current_date,_format1,_format2)If it doesn’t meet your requirement, could you please show the exact expected result based on the pbix that we have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hi Bosh ,
We can create a calculate column to meet your requirement.
Column =
var _month =MONTH('Table'[Date])
var _next_month = _month + 1
var _current_date = DATE(YEAR('Table'[Date]),_month,26)
var _next_date = DATE(YEAR('Table'[Date]),_next_month,25)
var _format1 = FORMAT(_next_date,"mmm")&" "&YEAR('Table'[Date])
var _format2 = FORMAT(_current_date,"mmm")&" "&YEAR('Table'[Date])
return
IF('Table'[Date]<_next_date && 'Table'[Date]>=_current_date,_format1,_format2)
If it doesn’t meet your requirement, could you please show the exact expected result based on the pbix that we have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hello Bosh , thank you for posting this, this helped me also.
v-zhenbw-msft Thank you for your solution. Just additional inquiry, would it be possible to make it as a DATE format and not as TEXT? But still the same "mmm YYYY"? Thank you so much!