topic Re: Compare data with previous period/last month in Desktop

Compare data with previous period/last month

SteveRB — Thu, 21 Sep 2017 15:49:22 GMT

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

Re: Compare data with previous period/last month

v-chuncz-msft — Fri, 22 Sep 2017 08:36:14 GMT

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 )
)

Re: Compare data with previous period/last month

SteveRB — Fri, 22 Sep 2017 12:05:47 GMT

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.

Re: Compare data with previous period/last month

SteveRB — Fri, 22 Sep 2017 12:21:16 GMT

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.

Re: Compare data with previous period/last month

v-chuncz-msft — Mon, 25 Sep 2017 08:42:10 GMT

SteveRB,

Take a close look at the third parameter.

Re: Compare data with previous period/last month

SteveRB — Tue, 26 Sep 2017 10:29:44 GMT

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?

Re: Compare data with previous period/last month

v-chuncz-msft — Wed, 27 Sep 2017 05:18:25 GMT

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.