The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |