cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Dynamically Change the Month and Year based on the current date in Power BI Desktop

Hello All,

 

I am stuck in the scenario where in i have to dynamically change the current month.

Below is the scenario of the same:

1. I have a column called Current Month which have certain values.

2. This column when added into the report table it should show the name of the Prev Month and the Year.

3. I have made certain Transformation which helped me to get the the Prev Month and Year as the Name of the Column, but whenever i change the data/Month name gets changed I have to manuall insert the column into the Table at report level.

 

Is there any work around for same as this is urgently required by the client and no manual intervention is required.

 

Please revert ASAP.

 

Regards,

Shraddha 

2 REPLIES 2

Re: Dynamically Change the Month and Year based on the current date in Power BI Desktop

Hey @Anonymous I can assist you with this. 






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

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Re: Dynamically Change the Month and Year based on the current date in Power BI Desktop

@parry2k How can we connect, I need Dynamically changing Column with the entire row conditional Formatting.

Regards,

Shraddha B

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,586)