Running Totals Measure question

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 current year, the PY(previous year) YTD (year to date) total is displayed for each month in the CY(current year). I would like to blank out those fieds in the matrix

Here is the dax measure i wrote to calculate the running totals in 20222, and then copied for another measure and adjusted for 2023

Running Total Labor 2022 =

CALCULATE(

SUM('Factory Payroll'[Grand Total Labor]),

FILTER(

ALL('Factory Payroll'),

YEAR('Factory Payroll'[Pay Date]) = 2022

&& 'Factory Payroll'[Pay Date] <= MAX('Factory Payroll'[Pay Date])

)

I would like to blank out the area circled above.

Thank you for your assistance in advance

Any links to pertaining to the topic at hand would be appreciated.

Drew

jihwan_kim · Answer

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.
&nbsp;

&nbsp;

&nbsp;
&nbsp;
&nbsp;
&nbsp;

westman · Answer

Jihwan_Kim&nbsp; &nbsp;Thank you for your assistance..Apologies im relatively new to Power bi and dax&nbsp;I formatted your measure below as:&nbsp;RT labor 2023 = Var _condition =&nbsp; &nbsp; Max('Datestbl'[Year] ) = 2023Return&nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp;Not ISBLANK([Total Payroll Wages] ),&nbsp; &nbsp;CALCULATE(&nbsp;[Total Payroll Wages], DATESYTD(&nbsp;'Datestbl'[Date] ))&nbsp; &nbsp; Divide ( _condition, _condition ))&nbsp;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&nbsp;Thankswestman