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
How can i achive that if I filter a date, it makes me the sum the amounts of the three months forward, and in a table it shows me the year, the months and the sum of the amounts by months, for example, if I filter 01/01/2021, show me the sums of the quantities in the months, January, February and March 2021, i did measurement, which does this to me, but the table does not show me the months these sums of quantities correspond.
Measure
Table
Date Filter
Pleas your help
Best Regard
Hernando
Solved! Go to Solution.
Hi @12400727
Try measure as:
SUMX(
FILTER(
ALL(Table1),
Table1[Customer])=MAX(Table1[Customer])
),
[3 Meses]
)
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @12400727,
Is your issue solved? If the issue has been solved, please adopt the solution to help others.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @12400727,
You can create a calculated table as:
Table2 =
VALUES('Table1'[Date])
Create measure as:
Measure =
CALCULATE(
SUM('Table1'[Value]),
DATESBETWEEN(
'Table1'[Date],
ALLSELECTED('Table2'[Date]),
DATEADD(ALLSELECTED('Table2'[Date]),2,MONTH)
)
)
Here is the output:
The pbix is attached, please try it.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi
i craeted two measurement:
1.
2.
Table Result:
Selected Date
i see the value 409 that corresponds to three months forward to the selected date, but my request is in order see in the table the years and the months that corresponds to the Three months forward, for example, if i select 03/07/2020, shows me the below image.
What can i do?
Thanks
Hi @12400727
Is this what you want?
The demo is attached, please try it.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi
Thanks for your help, i applied already your solution, but i have a quiestion for you, how can i apply a sum by customer, for example like you see the table below
The customer Carolina Marín Garcia has two records with value equal 2, but i want show the value 4, i want sum both records.
The measure called Recambio is the below
I gratefull your help.
Best regards
Hernando.
Hi @12400727
Try measure as:
SUMX(
FILTER(
ALL(Table1),
Table1[Customer])=MAX(Table1[Customer])
),
[3 Meses]
)
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi
i got an error, but i don't know what is the error. please help
Best regards.
Hi @12400727,
Your code has a formatting error.
Please refer: https://docs.microsoft.com/en-us/dax/sumx-function-dax
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
@12400727 Below article can help you in creating a mesure to calculate running total
for future months
https://community.powerbi.com/t5/Desktop/running-sum-of-future-3-month-data/m-p/663335
for past months, much more detailed here
https://www.goodly.co.in/running-total-power-bi/
Proud to be a Super User!
Hi
i already made the two measurements, and pleaced them in a table, however i do not see the expected result, it is not adding the next three months when i filter the date in the slicer.
For example i select the date
And the table shows the next
It is showing the quantity of the day selected (3), and the quantities of the month of the selected day (166).
i should see the sum of the three months following the selected day, only is showing the month of january.
Hi neggi007
I have a question for you, what i should put om what is highlighted in yellow?
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 |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |