Forum Discussion
Cardi0z
Helper I
Helper Ineed help to create measure Previous Month value
Dear All,
need help to create measure for showing data about Previous Month value.
today i am trying create measure below :
pa_prev_month =
CALCULATE(
SUM(PA[tot_prod]),
PREVIOUSMONTH(PA[date_k].[Date])
)
but, i am getting issue that value of previous month not calculated correctly
but, i am getting issue that value of previous month not calculated correctly
please help me
For your reference.
Calculation = EXPANDALL(SUM([M_Prev Sum]),ROWS)
Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
2 Replies
- Idrissshatila
Super User
Hello Cardi0z ,
can you please explain why you're assuming the data is wrong, because in your screenshot the data looks matching for the previous month.
- mickey64
For your reference.
Calculation = EXPANDALL(SUM([M_Prev Sum]),ROWS)
Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
