Forum Discussion

977roshan's avatar
977roshan
New Member
7 years ago
Solved

DATEADD / PARALLELPERIOD RETURNING SAME VALUE

Hi,   I'm trying to get a simple KPI that have current month Total Sales and Last month Total Sales. I already have the following measures for Total Sales.   Total Sales:=SUMX(sales,sales[Qty]*sa...
Data Modeling
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    977roshan ,

     

    You can modify you measure like pattern below and check if it can meet your requirement:

    Last Month Sales :=
CALCULATE (
    [Total Sales],
    FILTER ( DimDate, Dimdate[Date] = MONTH ( TODAY () ) - 1 )
)

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

977roshan ,

 

You can modify you measure like pattern below and check if it can meet your requirement:

Last Month Sales :=
CALCULATE (
    [Total Sales],
    FILTER ( DimDate, Dimdate[Date] = MONTH ( TODAY () ) - 1 )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.