topic Measure to calculate previous month values with a strict data context in Developer

Measure to calculate previous month values with a strict data context

binoobie — Fri, 21 Jun 2024 09:46:50 GMT

Hello fellow bi collegues,

I'm struggling to define a dax measure that would return the number of issues (I work with azure devops data) for the previous month only; kinda fixed context in the measure, what I did so far is:

!totClosedLastMonth = CALCULATE([!workItemCount],fact_devops[WorkItemType]="Issue",fact_devops[State]="Closed",DATEADD(dim_date[Date],-1,MONTH),USERELATIONSHIP(dim_date[Date],fact_devops[DATEKEYCLOSED]))

and it works but it requires to enforce context somewhere in filters, I'd like that measure to return a fixed value for the previous month comparing to the current one. How to do that?

Re: Measure to calculate previous month values with a strict data context

lbendlin — Fri, 21 Jun 2024 19:05:11 GMT

I'd like that measure to return a fixed value for the previous month comparing to the current one.

The interpretation of "current month" and "previous month" depends on the filter context. If you hard code that then you have to change your report design every month, Surely you don't want that?

Re: Measure to calculate previous month values with a strict data context

binoobie — Mon, 24 Jun 2024 09:18:29 GMT

Yes, I want a filter context (report level) to be fixed and restricted for current and previous month (given report display time by a report user) only - without letting user to get back deeper in the past. Not neccesairly want this to change every month and I already did that using variables and defining current and previous months using EOMONTH and TODAY functions.

Re: Measure to calculate previous month values with a strict data context

Anonymous — Tue, 25 Jun 2024 09:43:13 GMT

@lbendlin Thanks for your contribution on this thread.

Hi @binoobie ,

I still don't understand what your needs are? Could you please clarify your requirements? Are you attempting to calculate the difference between the current month’s value and the previous month’s value? If possible, providing sample data with Text format and practical examples would greatly assist in understanding your logic and desired outcome. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

Best Regards