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,
a have a problem, how to sum the sum column.
i have a exemple, a wont a sum column sum witch is sum jan in feb and a get 1+2 = 3 then 3+3 = 6 then 6+4 = 10,....
date | number | sum | |
jan | 1 | 1 | |
feb | 2 | 3 | |
mare | 3 | 6 | |
apr | 4 | 10 | |
maj | 5 | 15 | |
jun | 6 | 21 | |
jul | 7 | 28 | |
avg | 8 | 36 | |
sep | 9 | 45 | |
45 |
Please heal me.
LEa
Solved! Go to Solution.
Hi @LeaRupnik ,
Try this:
1. Create a Calendar table.
Calendar = CALENDAR ( DATE ( 2019, 1, 1 ), DATE ( 2019, 12, 31 ) )
2. Create columns in Calendar table.
Month = MONTH('Calendar'[Date])
Month Name = FORMAT('Calendar'[Date],"mmm")
3. Create relationship.
4. Create measures.
MTD = TOTALMTD(SUM('Table'[quantiti]),'Calendar'[Date])
YTD =
IF (
NOT ( ISBLANK ( MAX ( 'Table'[quantiti] ) ) ),
TOTALYTD ( SUM ( 'Table'[quantiti] ), 'Calendar'[Date] )
)
PBIX file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @LeaRupnik ,
If you have no other questions, please accept the previously useful response as a answer.
Best Regards,
Icey
Yes I am having the same issue! Help!
help?
What problem do you have, it the bast that you give the exact excaple.
LP
Lea
can you let me know when this sorted
Because there is no logical way to sort just the names of each month, this isn't possible. But add a date or the monthnumber (1-12) to your table and it is possible.
If you have the possibility to add a column with the number of each month or a column with a date you can use:
Hello,
this is work, but i have a table more complicated.
I have quantity according to date, then i have to sum a quantity to month, then to each month together.
ia have that kind of problem
date | quantiti | |
1.02.2019 | 2 | |
12.02.2019 | 5 | |
14.02.2019 | 5 | |
3.03.2019 | 4 | |
5.03.2019 | 6 | |
5.04.2019 | 2 | |
6.04.2019 | 5 |
|
and i would like to get this
feb | 12 | 12 |
mar | 10 | 22 |
apr | 7 | 29 |
29 |
thx Lea
Hi @LeaRupnik ,
Try this:
1. Create a Calendar table.
Calendar = CALENDAR ( DATE ( 2019, 1, 1 ), DATE ( 2019, 12, 31 ) )
2. Create columns in Calendar table.
Month = MONTH('Calendar'[Date])
Month Name = FORMAT('Calendar'[Date],"mmm")
3. Create relationship.
4. Create measures.
MTD = TOTALMTD(SUM('Table'[quantiti]),'Calendar'[Date])
YTD =
IF (
NOT ( ISBLANK ( MAX ( 'Table'[quantiti] ) ) ),
TOTALYTD ( SUM ( 'Table'[quantiti] ), 'Calendar'[Date] )
)
PBIX file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i a new in this, in Power bi and the forum.
The solution witch post it work. Now a have a problem how to sort the short month name. I don't want the number month.
tnx
Lea
Hi @LeaRupnik ,
Try this:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more 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 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |