cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShraddhaB Regular Visitor
Regular Visitor

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
Super User
Super User

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

Hey @ShraddhaB I can assist you with this. 




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

Proud to be a Datanaut!

www.perytus.com
(MVP Data Platform)


Highlighted
ShraddhaB Regular Visitor
Regular Visitor

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