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, I hope someone will be able to help me with the problem I have. I have a table that specifies student hours by term. For example, I want to know what is the difference in hours between Fall 2020 and Fall 2021. I tried inserting "fake" dates, connected them to the Date dimension table, and implemented the DATEADD function. But it would not give me the result I am looking for. I am suspecting this is because this is not a year-to-year comparison. But I still don't understand why this would not work.
This is my expression, and I had tables where it work just fine, but not for this one.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you!
You are welcome.
Yep, I tried what you offered and it does not return results. Also, in my expression the variable_CreditHoursSum was already a summarization, that is why I skipped SUM in my expression.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |