cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DL123 Frequent Visitor
Frequent Visitor

Returning a name of the month based on financial year

 

Hi,

 

 

I trying to create a measure where for if the dates are financial year of 2018/2019, to state the name of month.

 

so where:

 

financial year = “2018/19”

Month= Name of the month,  or else leave blank

 

So in the example below, the date 13 May 2018 , will have “May” in the month column, the other date will show as blank

 

Capture.PNGThanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Returning a name of the month based on financial year

@DL123  add new column with following DAX:

 

Month = IF( Table[Financial Yr] = "2018/19", FORMAT( Table[Date], "MMMM" ) )




Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




2 REPLIES 2
Highlighted
Super User
Super User

Re: Returning a name of the month based on financial year

@DL123  add new column with following DAX:

 

Month = IF( Table[Financial Yr] = "2018/19", FORMAT( Table[Date], "MMMM" ) )




Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




Community Support Team
Community Support Team

Re: Returning a name of the month based on financial year

Hi @DL123 

 

Kindly mark the helpful answer as a solution if you feel that makes sense.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.