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

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

        Hi,

        Thank you for your message.

        I think you can try using date column from Datestbl table, not from Factory Payroll table.

        Thank you.