Forum Discussion

yogiceg's avatar
yogiceg
Frequent Visitor
1 year ago
Solved

Power BI Visualization - Product materialization help

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 : [email protected]

Mobile/Whatsapp no : +91-9894030865

 

https://talemaindia-my.sharepoint.com/:x:/r/personal/yoganand_design_talemaindia_net/Documents/Desktop/Materialization%20Report.xlsx?d=w19cd6aa8d6e846c5abec84cd1894a7f2&csf=1&web=1&e=UJ92Ca 

Need Help
Show and Tell

5 Replies

    • _AAndrade's avatar
      _AAndrade
      Resident Rockstar
      1 year ago

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

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    1 year ago

    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")