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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Adding year to a set of months based on today's date.

Hello Everyone,

 

I have a report that covers all 12 months, which rotate (E.G. August 2018 - July 2019, then September 2018 - August 2019). The report changes each month, which currently is manually pulled, to be automated later. 

 

When I pull the report it does not contain the year (E.G. 2018 or 2019), which i want to add. 

 

Question - How do i add the year based on todays month/year to then add the year to the previous month understanding that once December comes its the previous year.

 

Example given -

 

August - 2018 (to add)

September - 2018 (to add)

October - 2018 (to add)

November - 2018 (to add)

December - 2018 (to add)

Note year change

January - 2019 (to add)

February - 2019 (to add)

March - 2019 (to add)

April - 2019 (to add)

May - 2019 (to add)

June - 2019 (to add)

July - 2019 (to add)

 

 

If there are any additional information needed let me know.

 

Thank you,

Deckhardt

1 REPLY 1
CheenuSing
Community Champion
Community Champion

Hi @Anonymous ,

 

Please upload your sample data to Google / One Drive and share the link here.

 

Cheers

 

CheeuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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