Forum Discussion

westman's avatar
westman
Regular Visitor
3 years ago

Running Totals Measure question

I am trying to figure out running totals. I have a matrix that has the previous years running total by month and the current year.  The aggregate correctly, however in the cells in the table under cu...
Running Totals
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

 

 

 

 

 

 

  • westman's avatar
    westman
    Regular Visitor
    3 years ago

    Jihwan_Kim   Thank you for your assistance..
    Apologies im relatively new to Power bi and dax

     

    I formatted your measure below as:

     

    RT labor 2023 =
    Var _condition =
        Max('Datestbl'[Year] ) = 2023
    Return
      IF(
           Not ISBLANK([Total Payroll Wages] ),
       CALCULATE( [Total Payroll Wages], DATESYTD( 'Datestbl'[Date] ))
        Divide ( _condition, _condition )
    )
     
    However, it returned zero data when applying it to the matrix visual. just blank all blank rows.
    Please see attached pic of datamodel and measure output
     
    Thanks
    westman
    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      3 years ago

      Hi, 

      Please share your sample pbix file's link, and then I can try to look into it.

      Thank you.

      • westman's avatar
        westman
        Regular Visitor
        3 years ago

        I am unable to attach files here as a newer user. I sent a pm to you with a one drive link to the file.

        I appreciate your assistance.

        westman