Power BI Exchange

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

Help with DAX measure - need to incorporate Parameters into measure

  • 1.  Help with DAX measure - need to incorporate Parameters into measure

    Posted Jan 13, 2022 07:59 AM
      |   view attached
    Hello,

    I  want to create forecasting scenario for one Measure (column E in attachment) over future Months.

    The Measure is based on Current Quantity on Hand Value and is not related to Date table.
    It should be used as a starting point in Calculation.
    For each next month Measure needs to include value from the previous month plus 3 parameters (user defined).
    None of the parameters, or measure are related to the Month (column A).

    Is there a way to create a Measure, such as in Column E in attached, so on each change of the Month previous value is added to the Parameters?

    Thanks,

    ------------------------------
    Tetyana Yatsenko
    Reporting Analyst
    NewAge Industries, Inc.
    Southampton PA
    2155262300
    ------------------------------

    Attachment(s)

    csv
    forec.csv   758 B 1 version