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.
Hi there,
in my report I've created the measure parallelperiod. What I need is the actuals of this year in comparison with the actuals of last year over the months. Because there is no data of this year for July and further the measure shows no data for these months for last year.
The measure is:
There is a print screen attached.
What I need is the whole of last year and the actuals of this year till the current month.
Thank you for your advice.
Solved! Go to Solution.
Hi @Mengeltje
Use the Date column from Date table into the Matrix. And you may consider using SAMEPERIODLASTYEAR or DATEADD functions to get the same result.
Time Comparisons In Power BI: This Year vs Last Year | Enterprise DNA
DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question - RADACAD
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi @Mengeltje
Use the Date column from Date table into the Matrix. And you may consider using SAMEPERIODLASTYEAR or DATEADD functions to get the same result.
Time Comparisons In Power BI: This Year vs Last Year | Enterprise DNA
DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question - RADACAD
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |