Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
PREVIOUSYEAR (Doesn't fail but returns no data). The Date column in my Calander is set to "Date". Here's the formula:
Solved! Go to Solution.
Thank you for the reply. I kept working with it and when I took the SUMX out fo the formula it worked and now shows data. Don't quite understand why as I thought you had to use another formulas with CALCULATE.
Thanks,
John
Thank you for the reply. I kept working with it and when I took the SUMX out fo the formula it worked and now shows data. Don't quite understand why as I thought you had to use another formulas with CALCULATE.
Thanks,
John
Hi @kozlevchar check that you have a date table and that it's marked as one. PREVIOUSYEAR is a time intelligence function and requires a date table in order to work properly.
Hi,
Thank you for the reply. I have Date table and it's marked as a Date Table
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |