Compare data with previous period/last month

[SteveRB]

Hello i've looked through many posts, and i am unable to find a solution to my issue.

I have a table that is presenting reporting %'s

I want to be able to present the same Report Form against the previous month.

Steps i have taken so far, i have created a date table (see below)

I have linked it up with my table, using the month number

This is my table with the data in, i need to show on a graph the previous month's data. I.E Feb E2B Drug  vs Jan E2B drug?

If i include the report forms as a filter, they stack up the month's rather than split them as two individual figures on a graph?

Any solution will greatly be appreciated

Thanks

[v-chuncz-msft · Accepted solution]

@SteveRB,

You could first add a calculated column.

Prev =
LOOKUPVALUE (
    Table1[% on time],
    Table1[Report Form], Table1[Report Form],
    Table1[Monthno], DATE ( YEAR ( Table1[Monthno] ), MONTH ( Table1[Monthno] ) - 1, 1 )
)

[SteveRB]

Hello, thanks your reply.

I've used the steps as advised and recieve the following error message

To be clear, i am trying to compare the data that is in the same table, I.E January E2B against Feb's?

I may have gone wrong somewhere, i'm really new to Dax, so can't really troubleshoot that well.

[v-chuncz-msft]

@SteveRB,

Take a close look at the third parameter.

[SteveRB]

Thanks, slowly getting there :). I think

How do i get around this? I typed in excel 01/01/2017 and Power Bi changes it to 1 January 2017?

[v-chuncz-msft]

@SteveRB,

Again, take a closer look at the formula. To change the format, you may select the column and then use the Format drop-down menu from Modeling tab.

[SteveRB]

Just to add further clarification and understanding of my issue

The below screenshot, is showing two months of E2B data however they are collating into the one column rather than splitting across the months

My aim is to get them split across the two month.