In services, how can I retrieve the name of the month from the date?

[ajaykumar7960]

Hello All,

A report is created in Power Bi Services in Direct Lake mode with only one date column, Can anyone lend us a hand in extracting the monthwise column (formatted 'MM') from the date column in Power BI Services? As I said, we are using DirectLake mode for PowerBI reports and using the PowerBI service to author the reports.

I have explored the use of a semantic model, visual query level, and measures.
Monthwise =
var Monthtable=
ADDCOLUMNS('Table',"Month",MONTH('FACT_CRM_'[SNAPSHOTDATE])
)
RETURN
GROUPBY(Monthtable,FACT_CRM_PROFI[SNAPSHOTDATE],"Count",COUNTX(CURRENTGROUP(),FACT_CRM_SNAPSHOTDATE]).

I would be grateful if you could lend a hand.

[lbendlin]

Have you considered using FORMAT([date],"mmmm")  ?

[ajaykumar7960]

Hi Thanks for reply, but its not allowing for date 

As I am using (Fabric) DirectLake mode for PowerBI report and using PowerBI service to author the report.

[lbendlin]

You should still be able to do that in a visual calculation.

[ajaykumar7960]

Thanks for replying i will check with that and update you.

[v-jianpeng-msft]

Your ideas is so great  @lbendlin 
Hi,  @ajaykumar7960 
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster. Thank you very much for your kind cooperation!

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

Jianpeng Li