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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.