cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## 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 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.

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

Drew
5 REPLIES 5
Super User

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Regular Visitor

@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
Super User

Hi,

Thank you.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Regular Visitor

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.

westman

Super User

Hi,

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

Thank you.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors