Compare a specific month from last year end

[Anonymous]

Hi,

I know this is a repeated topic but i couldnt seem to fix my measure to find the % variance between Sept 2019 and Dec 2018 balances:

Currently this is what my matrix looks like and its based on one appended table:

Appreciate if anyone could assist.

Thank you.

[parry2k]

@Anonymous your screen shot is not loaded. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi @parry2k,

Sorry, didnt realise it. Should be uploaded in the original post.

Thanks

[parry2k]

@Anonymous how your sample data looks like, it is import to know that before provide the solution.

[Anonymous]

Hi @parry2k ,

My sample data looks like this

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I created a sample that you could try.

• Please create a calendar table firstly.

Date = CALENDARAUTO()

 

• Then create a measure

Measure = CALCULATE(SUM('Table'[Netbal_iis]),DATEADD('Date'[Date],-1,YEAR))

 

Reference:

https://radacad.com/dateadd-vs-parallelperiod-vs-sameperiodlastyear-dax-time-intelligence-question

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous not sure if you already have date calendar in your model or not, if not then add one, there are many post on how to do this. and from there it will be very easy to create all these calculations.

here is one blog post talks about compare values wiht previous year.