Have salary raise (dummy) data - trying to visualise the months in between raises

[Anonymous]

Hello, 

our company has data on when people have been given raises - as seen in the dummy data above. The HR manager would like to visualise this data, showing people's salaries in between their raises (she is not bothered by getting the actualy monthly salary, she just wants to visualise for every month in between what the annual salary of the employee was. 

So let's take Angela for example, she wants to show Angela's salary as 55,000 from July 2012 to July 2019, and then 80,000 from August 2019 goinf forwards. How can we achieve that? 

If this is about adding new rows into the data for all of the missing months (grouped by employee), could someone help me do this? 

Even better, is there a way to calculate this as a measure that would work on a line chart? (showing all of the months in between July 2012 to August 2019 as 55k for Angela, rather than just two spikes in July 2012 and August 2019). 

Thank you, 

your help is greatly appreciated. 

[ChrisMendoza · Accepted solution]

@Anonymous -

Using Power Query you can likely acheive your desired results as I proposed in this post https://community.powerbi.com/t5/Desktop/Writing-Rows-in-a-Calculated-Table-From-Flat-Data-and-Building-a/m-p/786013#M378542

[Anonymous]

I mean it's not the solution I am looking for, but sure, since other people can accept solution on my behalf, you can have it, I guess?

[v-chuncz-msft]

@Anonymous 

You may drag date from a separate calendar table and use the following measure.

Measure =
VAR d =
    MAX ( 'Table 2'[Date] )
RETURN
    MAXX (
        TOPN ( 1, FILTER ( 'Table', 'Table'[Date] <= d ), 'Table'[Date], DESC ),
        'Table'[Salary]
    )

[Anonymous]

Nope, this just shows the two months - their initial salary and their raise. On a line graph, this doesn't fill in the months in between. Sorry, not what I'm looking for. Thank you though.