Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Question:
Hi all, I am trying to make the previous year measures to appear in the table. The dax I use is
Attrition Rate Last Year = CALCULATE([Attrition Rate Overall], DATEADD('Headcount'[Period],-1,YEAR))
but, when I apply it to the table, the value don’t show up. Any reason?
I mean, the one in the Date table
In order to use any time intelligence calculation, you need a well-formed date table. The Date table must satisfy the following requirements:
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Thanks @ERD
I created the Date table and Link it to the date column required. The measure still dont appear..
you can try to use SAMEPERIODLASTYEAR
PY_Value = CALCULATE([CY_Value], SAMEPERIODLASTYEAR('Date'[Date]))
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
i used this too. but it didnt come out.
my CY_Value is a measure calculated with this formula. Somehow the CY_Value appear but the PY_Value is empty. I am not sure why too.
Can you provide a pbix file with sample data? Or at least sample table in table format.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
40 | |
20 | |
12 |