Forum Discussion

binoobie's avatar
binoobie
New Member
2 years ago

Measure to calculate previous month values with a strict data context

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 measu...
General Comment
binoobie's avatar
binoobie
New Member
2 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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