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.
Hi All,
I was wondering if someone can help me. I am still new to Power BI. Basically i wold like to create measure that will only show the value of the specific year. See the picture. I would like to have the sum of all sales in each year 2014, 2015, 2016 as separated result. Can you help?
Solved! Go to Solution.
The best way to create this is to create a Date table.
Once you have created your date table you can create a relationship between your tables. After which you can use the columns in your Date table to group the data as needed.
Here is my blog post on how to create the Date Table: https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fi...
The best way to create this is to create a Date table.
Once you have created your date table you can create a relationship between your tables. After which you can use the columns in your Date table to group the data as needed.
Here is my blog post on how to create the Date Table: https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fi...
Thanks for you help. I couldn't manage that in the way you explained but i found a different approach. I will try your way also but i had to finish this quickly.
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 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |