Forum Discussion

SWATIC's avatar
SWATIC
Regular Visitor
5 years ago
Solved

PREVIOUS DAYS VALUE WITH CURRENT DATE VALUE

I want to show previous days value with current days value. Tried below formula but in previous days value shown same as current days value. Particular issue is still pending.   Created Date table...
General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi SWATIC 

    Please check whether you build a relationship between BRAND WISE PRICE-VERT  Table and Data table by Date column.

    I have a test by your calculated column:

    PREVIOUS DAYS PRICE = CALCULATE(average('BRAND WISE PRICE-VERT'[CURRENT DAY PRICE]),DATEADD('date'[Date],-1,MONTH))

    It works well.

    If we delete the relationship, it will make the result to show previous price equal to current price.

    Best Regards,

    Rico Zhou

     

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

SWATIC's avatar
SWATIC
Regular Visitor
5 years ago

 

Yes using below date :

 

Created Date table :-

1 :- date = CALENDARAUTO()

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi SWATIC 

Please check whether you build a relationship between BRAND WISE PRICE-VERT  Table and Data table by Date column.

I have a test by your calculated column:

PREVIOUS DAYS PRICE = CALCULATE(average('BRAND WISE PRICE-VERT'[CURRENT DAY PRICE]),DATEADD('date'[Date],-1,MONTH))

It works well.

If we delete the relationship, it will make the result to show previous price equal to current price.

Best Regards,

Rico Zhou

 

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