Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Diego_06
New Member

Sumar datos de un periodo

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.

 

Diego_06_0-1693074431466.png

 

3 REPLIES 3
technolog
Super User
Super User

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.

Anonymous
Not applicable

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])

vyangliumsft_0-1693291031367.png

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])

vyangliumsft_1-1693291031369.png

 

 

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

lbendlin
Super User
Super User

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...

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.