Forum Discussion

172heavy's avatar
172heavy
Frequent Visitor
9 years ago
Solved

Time Intelligence YTD Based on a Measure

I have what should be a very simple problem that has been very challenging to overcome. I suspect I am complicating it!   I am trying to show the depreciation curve as assets reach the residual val...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    172heavy

    One thing that stands out immediately in the formula

    You need to get (filter) allselected dates up to the current date you are on...

     

    Sum_Depr_Calc_End_Date =
CALCULATE (
    SUM ( tbl_OnOffRentStatusRO[MonthlyDepr] ),
    FILTER (
        ALLSELECTED ( tbl_OnOffRentStatusRO ),
        tbl_OnOffRentStatusRO[Deprecation_End_Date].[Date]
            <= MAX ( tbl_OnOffRentStatusRO[Deprecation_End_Date].[Date] )
    )
)

     

    Good Luck! :smileyhappy:

     

Sean's avatar
Sean
Community Champion
9 years ago

172heavy

One thing that stands out immediately in the formula

You need to get (filter) allselected dates up to the current date you are on...

 

Sum_Depr_Calc_End_Date =
CALCULATE (
    SUM ( tbl_OnOffRentStatusRO[MonthlyDepr] ),
    FILTER (
        ALLSELECTED ( tbl_OnOffRentStatusRO ),
        tbl_OnOffRentStatusRO[Deprecation_End_Date].[Date]
            <= MAX ( tbl_OnOffRentStatusRO[Deprecation_End_Date].[Date] )
    )
)

 

Good Luck! :smileyhappy: