Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi
i have numbers with a date and i want to sum all numbers with its date or year
example 2014/1/1 = 12
2014/1/5 = 10
2015/5/14 = 5
2015/12/6 = 15
the mesure or (column) must show table like
2014 = 22
2015= 20
pleas help
best regards,
Solved! Go to Solution.
Hey,
from my understanding it's not necessary to create a calculated column or measure.
I just entered some sample data:
Then I checked if the data type of the Date column has been recognized as date or datetime (I almost switch to date every time). Please be aware that the Date Hierarchy will be created automatically.
Adjust the format to your liking, the essential part is the data type
Then it's possible to create a visual just by dragging and dropping the columns to a table visual. This behavior is the standard behavior of Power BI.
If you want to create more advanced analytical reports it will become essential that you create a dedicated Calendar table, this article covers almost everything that is important for this: https://www.daxpatterns.com/time-patterns/
I attached the file to this post.
Regards,
Tom
If the Date Hierarchy is not created automatically this is how to turn this on:
Sooner or lated (often sooner it is a good idea to turn this option off), but for a start it is okay.
You cn use the quick measure for filtering your numbers by year.
Hey,
from my understanding it's not necessary to create a calculated column or measure.
I just entered some sample data:
Then I checked if the data type of the Date column has been recognized as date or datetime (I almost switch to date every time). Please be aware that the Date Hierarchy will be created automatically.
Adjust the format to your liking, the essential part is the data type
Then it's possible to create a visual just by dragging and dropping the columns to a table visual. This behavior is the standard behavior of Power BI.
If you want to create more advanced analytical reports it will become essential that you create a dedicated Calendar table, this article covers almost everything that is important for this: https://www.daxpatterns.com/time-patterns/
I attached the file to this post.
Regards,
Tom
If the Date Hierarchy is not created automatically this is how to turn this on:
Sooner or lated (often sooner it is a good idea to turn this option off), but for a start it is okay.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |