Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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?
https://www.youtube.com/watch?v=JNt-_QByeLk
https://www.youtube.com/watch?v=zYIxukD2KCM
Regards
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?
https://www.youtube.com/watch?v=JNt-_QByeLk
https://www.youtube.com/watch?v=zYIxukD2KCM
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |