Power BI Exchange

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

View My Drafts

Back to discussions
Expand all | Collapse all

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