Forum Discussion
sambgv
Helper I
Helper IDaily to Day changes in matrix
my ultimate goal is to display daily resource changes in a matrix. let me explain: Suppose, Team A requested YESTERDAY the role Engineer for February 2025 for a project in quantity of 5. Today th...
Hi sambgv ,
Based on your description, would you like to show both each month's data when the user has selected Team and Role, as well as show the growth of the current month compared to the previous one?
If I understand correctly, you can add such a measure to the matrix.
increase =
VAR _previous =CALCULATE(SUM('Table'[value]),ALL('Table'),MONTH('Table'[Month])=MONTH(MAX('Table'[Month]))-1,'Table'[team]=MAX('Table'[team]),'Table'[role]=MAX('Table'[role]))
VAR _current = SUM('Table'[value])
RETURN _current-_previous
Best regards,
Mengmeng Li
sambgvHelper I
Helper Ithanks for your efforts. almost there!
my example:
VAR Recent =
CALCULATE(
SUM(table [value]),
LASTDATE(table[date_updated])
)
VAR Previous
date_updated column is the key here. it's the date from a database. it's when the data gets refreshed. and it's refreshed everyday. so i need the latest update - previous updates to see the resource changes for all months, teams, and roles.
VAR Previous
CALCULATE(
SUM(table [value]),
LASTDATE(table[date_updated]) - 1
)
RETURN
Recent - previous.
RETURN
Recent - previous.
date_updated column is the key here. it's the date from a database. it's when the data gets refreshed. and it's refreshed everyday. so i need the latest update - previous updates to see the resource changes for all months, teams, and roles.
Hi sambgv ,
What do your current results look like? Can you provide screenshots and a pbix file(without private data)?
Best regards,
Mengmeng Li