Calculate % difference in MOM measures

YcnanPowerBI — Tue, 18 Jun 2024 02:28:03 GMT

Hoping this is a simple one for someone.

I have a measure that divides repeat callers by all callers within 2 days for our repeat rate. I am diplaying that measure monthly. I would like to calculate the difference +/- from May to June and so on. Any help is greatly appreciated.

Measure being used:

Repeat Rate = DIVIDE([1 Count Repeats],[1 Count All Calls])

Sample Data:

Ticket Category _CSG	Leg - Date	Calls
Point of Sale::Printing	15-Jun-24	1
Restaurant Management::Employees	16-Jun-24	1
Point of Sale::Printing	15-Jun-24	1
Point of Sale::Printing	15-Jun-24	1
Restaurant Management::Licensing	15-Jun-24	1
Windows Issue::Operating System	16-Jun-24	1
Point of Sale::Reports	15-Jun-24	1
Credit Cards::Batching	15-Jun-24	1
Point of Sale::Close Day	15-Jun-24	1
Windows Issue::Windows Services	16-Jun-24	1
Point of Sale::Balance Drawer/Cashout	15-Jun-24	1
Point of Sale::Printing	15-Jun-24	1
Point of Sale::Order Entry	16-Jun-24	1

Expected Outcome:

Re: Calculate % difference in MOM measures

Anonymous — Tue, 18 Jun 2024 03:04:01 GMT

Hi YcnanPowerBI

First, you can use the following DAX to get the repeated calls every two days:

Repeat Count per two day = VAR _selectdate = DAY(SELECTEDVALUE('Table'[Leg - Date])) RETURN CALCULATE(COUNTROWS('Table'),FILTER('Table',DAY('Table'[Leg - Date])=_selectdate||DAY('Table'[Leg - Date]=_selectdate+1)))

Then you can use the following DAX to get the ratio of repeat calls to total calls and the difference for each month:

Divide = VAR _selectmonth = MONTH(SELECTEDVALUE('Table'[Leg - Date])) VAR reprtcount = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),MONTH('Table'[Leg - Date]) =_selectmonth&&[Repeat Count per two day]<>1)) VAR countpermonth = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),MONTH('Table'[Leg - Date])=_selectmonth)) RETURN reprtcount / countpermonth

Difference = VAR _selectmonth = MONTH(SELECTEDVALUE('Table'[Leg - Date])) RETURN [Divide] - CALCULATE([Divide],FILTER(ALL('Table'),MONTH('Table'[Leg - Date])= _selectmonth-1))

Best Regards,

Jayleny

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

topic Calculate % difference in MOM measures in DAX Commands and Tips

Calculate % difference in MOM measures

Re: Calculate % difference in MOM measures