Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Smartnag
Frequent Visitor

Year and month with current month

Hi All,

 

I have data like below table.

Source of data - Excel

 

Req -  calculate current year current month of A,B,C 

Month-valA,valB,valC;2022-00,0.20,0.90,0.40;2022-01,0.20,0.90,0.40,2022-03,0.20,0.90,0.40

Data month is in Year-month format.

 

Thanks,

Smartnag

1 REPLY 1
amitchandak
Super User
Super User

@Smartnag , Can paste it in table format. And provide source vs output needed

 

How to paste data on community

https://youtu.be/1_XlyzV-PcY?t=272

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.