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.
Hello,
1. Salaries are reported annually. However, they can change each month.
2. Bonuses are paid irregularly over different months.
I am trying to achieve:
Show in the table "Yearly Salary Vs Bonus" the correct results for Salary and Bonus while selecting a specific Month. OR if Selecting a YEAR from the year slicer, I would like the Salary of DEC of that year.
Please see link for the file.
https://basintamir-my.sharepoint.com/:u:/g/personal/tamir_tamirbasin_com/EbeTLvJsTwJGpYaV4f-6m44BbHN...
Thank you
Tamir
Hi @Anonymous,
You could create a measure below to meet your requirement.
Annual_Salary = IF ( ISFILTERED ( dimCalendar[MonthYear] ), MAX ( 'factsSallaries'[Annual Salary] ), CALCULATE ( SUM ( factsSallaries[Annual Salary] ), FILTER ( 'factsSallaries', 'factsSallaries'[Date] = ENDOFYEAR ( 'factsSallaries'[Date] ) ) ) )
The picture of result is below.
Picture_1 --no filter
Picture _2--by selecting the specific month
Additionally, you could refer to the PBIX file here.
Hope it can help you!
Best regards,
Cherry
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |