Forum Discussion

Aproksymacja's avatar
Aproksymacja
New Member
2 years ago

Measures Power BI

Hi, I'm totally new in Power BI world and I would like to create a measure which will calculate  a change between values for  Jan-23 and values for next months. So in this matix I would like...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Aproksymacja 

Can you please try in the above DAX, last line where BLANK(), please replace with 1

Measure = 
VAR _LastMonthSales = 
CALCULATE(
    Sum(Table[Sales]),
    PARALLELPERIOD(
        'Calendar'[Transaction_Date],
        -1,
        MONTH
    )
)
RETURN
% of Change Sale = 
DIVIDE(
    (Sum(Table[Sales])- _LastMonthSales),
    _LastMonthSales,
    1
)


Let me know

If your requirement is solved, please make THIS ANSWER as SOLUTION

Aproksymacja's avatar
Aproksymacja
New Member
2 years ago

It helped for January, it is visible now, but calculations are not proper

In your solution 0.977(Jun) = Jun/May

 

I would like to have 0.94 (Jun) which is 164498412(Jun)/174792138(Jan)

 

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Aproksymacja 

    Try this

    Measure = 
VAR _LastMonthSales = 
CALCULATE(
    Sum(Table[Sales]),
    PARALLELPERIOD(
        'Calendar'[Transaction_Date],
        -1,
        MONTH
    )
)
RETURN
% of Change Sale = 
If(ISBLANK(_LastMonthSales) || _LastMonthSales =0,
1,
DIVIDE(
    (Sum(Table[Sales])- _LastMonthSales),
    _LastMonthSales,
    BLANK()
)

     

    f your requirement is solved, please make THIS ANSWER as SOLUTION

     

    • Aproksymacja's avatar
      Aproksymacja
      New Member
      2 years ago

      Unfortunatelly now I have 1 everywhere.

       

      • PijushRoy's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Aproksymacja 

        Please create a pbix that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link in this thread. If you are using a spreadsheet to create/import the sample data instead of the manual import method, share the spreadsheet as well. 

        OR share sample data in excel format