Power BI Visualization - Product materialization help

[yogiceg]

Hi Team

i am new to Power BI. Pls refer below excel file & I would like to visualize YYYY-MM vs percentage in power BI. In that excel file, i am doing it by manually (counting YYYY-MM in two columns) & wants Power BI to make such calculation directly from the data sets. Pls help & advance thanks.

Mail ID : yoganandceg@gmail.com

Mobile/Whatsapp no : +91-9894030865

https://talemaindia-my.sharepoint.com/:x:/r/personal/yoganand_design_talemaindia_net/Documents/Deskt... 

[_AAndrade · Accepted solution]

Hi @yogiceg,

I'm attaching a pbix file with my solution.
The final output was this:

[_AAndrade]

Great. If my post solved your issue, please mark my post as a solution and give me a Kudo if I deserve one.
Thanks

[yogiceg]

Hi @_AAndrade 

Thanks for the details. Very useful.

[PijushRoy]

Hi @yogiceg 

In calculated column, please use below DAX

YYYY-MM = 
YEAR('YourTable'[DateColumn])&"-"&MONTH('YourTable'[DateColumn])

In Power Query Custom Column, use below M Code

Date.ToText([DateColumn],"yyyy-MM")

[yogiceg]

Hi @PijushRoy 

Thanks.