calculate the change from latest date from earliest date from a table
Hi - I have a table in Power BI like so Company Value Month-Year Head office 42 Jan 23 Head office 53 Jun 23 Head office 63 Dec 23 Factory 56 Jan 23 Factory 65 Jun 23 Factory 67 Dec 23 Etc And I'm looking for DAX that would show the difference from the latest date in the table to the earliest date; so Dec 23 value - Jan 23 value, as a number and a percentage for each company - can anyone help me out with that? Thanks!