Reply
Regular Visitor
Posts: 19
Registered: ‎02-08-2018

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 

Super User
Posts: 1,974
Registered: ‎07-22-2015

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)


Regular Visitor
Posts: 19
Registered: ‎02-08-2018

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

[ Edited ]

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

Regards,

Shraddha B