DAX Code to calculate custom half month on half month change

[ajay_gajree]

Hi All

I have bucketed my data into two dates in a month, all records in the first half of the month are assigned to 15/xx/xxxx

All records from the 16th of the month are bucketed into whatever the last date of the particular month is.

My date filter has these dates, so for example the user will see

15/05/2020

30/04/2020

15/04/2020

31/03/2020

15/03/2020

29/02/2020

15/02/2020

And so on

What I want to be able to do is say count records bucketed for the date selected and then return the difference to the previous date in the list.

A bit like month on month change but for these customs dates.

Not sure how to do this!

Any help or pointers appreciated!

[amitchandak · Accepted solution]

@ajay_gajree , Create a period rank, on period start date

Period Rank = RANKX(all('Date'),'Date'[Period Start date],,ASC,Dense)

This Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]=max('Date'[Period Rank])))
Last Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]=max('Date'[Period Rank])-1))

change = [This Period] - [Last Period ]

change % = divide([This Period] - [Last Period ],[Last Period ])

Discussed in my video : https://www.youtube.com/watch?v=7Jc3D4iaTqs 

[parry2k]

@ajay_gajree bucket part is ok but not sure what you exactly want the output to be, if you share sample data with the expected output, it will help understand the problem.