Power BI for Developers

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

DAX Measure to calculate month end value dynamically

  • 1.  DAX Measure to calculate month end value dynamically

    Posted Dec 07, 2021 05:25 AM
    Hi,

    I have power bi report and would like to create a DAX measure to calculate the SLA % of the total but for the last month dynamically.

    Here is a sample of my data:

    Month Year Within SLA Total % within SLA
    Sep-21 10 50 20
    Oct-21 5 50 10
    Nov-21 7 100 7

    I would like to create a measure to work out the Nov21 % SLA
    but I would like the calculation to be dynamic so that is uses the last month measure.

    So when we run the report is run again in say January it uses Dec21 for calculating the %SLA.

    Thanks





    ------------------------------
    Abdulaziz Nasaar
    ------------------------------