Forum Discussion
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.
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? :smileyhappy:
https://www.youtube.com/watch?v=JNt-_QByeLk
https://www.youtube.com/watch?v=zYIxukD2KCM
Regards
1 Reply
- v-ljerr-msftMicrosoft Employee
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? :smileyhappy:
https://www.youtube.com/watch?v=JNt-_QByeLk
https://www.youtube.com/watch?v=zYIxukD2KCM
Regards