Forum Discussion
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...
PijushRoy
Community Champion
Community ChampionHi 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
Unfortunatelly now I have 1 everywhere.
- PijushRoy
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