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,
Actully I'm craeting a KPI .
Calculate Average price diffrence (Period to Same Period before/last year) :
Taking average of products in the date range and same range last year but matching proucts only. Basically a Inner join of product (selected period products inner join with same period last year products)
For ex: From below image if user has selected date rage of 01-Feb-2021 to 05-Jun-2021, then prod(A,B,C,D)Average will be 66.75, but for same period in last year product D is not present then we want to exclude tht product from avg cal. so, new avg will be prod(A,B,C) 61.66 and same period last year prod(A,B,C) avg is 45. and diffrence will 61.66-45.
Name | Department | Value | Product | Year | Date(DD-MM-YYYY) |
Alex | Tech | 99 | A | 2021 | 01-02-2021 |
Scott | Disp | 47 | B | 2021 | 10-02-2021 |
Ray | Tech | 39 | A | 2021 | 10-02-2021 |
Joy | Disp | 82 | D | 2021 | 04-06-2021 |
Alex | Tech | 27 | A | 2020 | 01-02-2020 |
Alex | Tech | 53 | B | 2020 | 10-02-2020 |
Alex | Tech | 55 | B | 2020 | 15-02-2020 |
Hlp me resolving this issues. Thanks in advance .
Solved! Go to Solution.
Hi,
Please check the below picuture and the attached pbix file.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picuture and the attached pbix file.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you for quick help.
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |