Forum Discussion

arpost's avatar
arpost
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Help! How do I summarize and get a running total using DAX?

Greetings, PBI community! Have an interesting conundrum and wanted to see if anyone could offer a solution. Here's the two parts of the scenario with an example.   Let's say I have a dataset set up...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    thank you for your feedback, and please check the attached pbix file if it suits your requirement.

     

    Thank you.

arpost's avatar
arpost
Icon for Post Prodigy rankPost Prodigy
3 years ago

Greetings, Jihwan_Kim! Thanks for the reply. That's really helpful.

Quick question: this requires that there is a separate dimension table (Customers). Any chance you know of a solution that can work on the data in the data table itself? To put it another way, is there a form of the above that would work with just a Calendar table and a Data table?

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

thank you for your feedback, and please check the attached pbix file if it suits your requirement.

 

Thank you.

  • arpost's avatar
    arpost
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    Boom! That worked like a charm. 😁 Thanks for the help. I'm trying to figure out a related (but somewhat different) issue over here (link) as well, so if you have any sage advice you could offer, that'd be appreciated,