Forum Discussion

Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
6 years ago
Solved

Invoicing Date Month value

Hi everyone. I have a calendar table set up. Our invoicing is run on the 28th of the month and for a forecast I would like to have a column in my calendar taking account of this as the end of the "in...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Pmorg73 ,

     

    Think you could use Format(value,"MMM").

    For example

    Column = IF('Table'[date].[Day]<28,FORMAT('Table'[date],"MMM"),FORMAT(EDATE('Table'[date],1),"MMM"))

    And the result as below

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Pmorg73 ,

 

Think you could use Format(value,"MMM").

For example

Column = IF('Table'[date].[Day]<28,FORMAT('Table'[date],"MMM"),FORMAT(EDATE('Table'[date],1),"MMM"))

And the result as below

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.