Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Buenas tardes grupo, quisiera saber como hacer un calculo que solamente me sume los datos de un periodo basado en esta información.
Gracias de antemano.
I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.
Your insights and updates will greatly assist others who might be encountering the same challenge.
Hi @Diego_06 ,
What do you mean by "adds the data of a period", is it based on the period of time selected by the slicer. Since your language is not English, there will be some gaps in the translation, so if the answer below doesn't meet your expectation, you can express your expectation in the form of a picture and we can help you better.
You can directly use the date column to act as a slicer to filter the dates in the table, and use measure to add up the values of the time periods.
Measure1 =
SUMX(
ALLSELECTED('Table'),'Table'[SumaDeColones])
If you don't want to affect the data in the table, you can create an unrelated calendar table to act as a slicer and use measure to add up the values of the time periods.
Measure2 =
var _mindate=MINX(ALLSELECTED('Table 2'),[Date])
var _maxdate=MAXX(ALLSELECTED('Table 2'),'Table 2'[Date])
return
SUMX(
FILTER(ALL('Table'),
'Table'[Fecha] >= _mindate&&'Table'[Fecha]<=_maxdate),[SumaDeColones])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
18 | |
15 | |
7 | |
6 |