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

Using TI to create automatized reports

I am currently working on a project which involves multiple monthly reports. The company's idea is to try to rely as less as possible in manual work. They need comparisons between months (i.e: last three months: dec, nov and oct), last year,etc. . In most cases, it involves conditional functions, like "all values from december which were made manually".

I am new to Power BI and even more to DAX, so as you can see I´m struggling to find a solution. As I see it, one way is to make reports with charts fed with values based sorely on DAX functions, more specifically TI functiones.  That way, every month the only thing we need to do is refresh the .pbix doc with the new data input.

I am not sure this is the right way, or if there is a better, more efficient one. 

 

Any advice regarding this issue, or wiki, video, article, would help. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Using TI to create automatized reports

Hi @Anonymous,

 

Followings are some good videos about how to calculate Difference This Year vs Last Year in Power BI with DAX, and show MTD, QTD & YTD Calculations To Current Date in Power BI w/DAX. Could you go to check if it helps in your scenario? Smiley Happy

 

https://www.youtube.com/watch?v=JNt-_QByeLk

https://www.youtube.com/watch?v=zYIxukD2KCM

 

Regards

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Using TI to create automatized reports

Hi @Anonymous,

 

Followings are some good videos about how to calculate Difference This Year vs Last Year in Power BI with DAX, and show MTD, QTD & YTD Calculations To Current Date in Power BI w/DAX. Could you go to check if it helps in your scenario? Smiley Happy

 

https://www.youtube.com/watch?v=JNt-_QByeLk

https://www.youtube.com/watch?v=zYIxukD2KCM

 

Regards

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors