Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

FIlter Line chart DAX Formula by 1 year

I have a DAX Measure as shown below SPLY INVoiced = CALCULATE( [Invoice Line Total],SAMEPERIODLASTYEAR('Date'[Date]))   The goal is to filter the 1 yr that is added so that all the l...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    After doing some extensive research, this is my answer

    SPLY Sales Amount = 
IF(MONTH(TODAY()) >= SELECTEDVALUE('Date'[Month Num]) && YEAR(TODAY()) = SELECTEDVALUE('Date'[Year]),
CALCULATE(Sum('Sales'[Price]),SAMEPERIODLASTYEAR('Date'[Date])
),Blank())
darkinvader_'s avatar
darkinvader_
Icon for Resolver I rankResolver I
3 years ago

Hi Anonymous , You can use the below formula :-

Last Year Invoice Line Total =
VAR MaxDate = MAX('Date'[Date])
VAR LastYearEndDate = EOMONTH(MAX('Date'[Date]), -12)
VAR LastYearStartDate = EOMONTH(LastYearEndDate, -11)
RETURN
CALCULATE( [Invoice Line Total], FILTER( ALL('Date'), 'Date'[Date] >= LastYearStartDate && 'Date'[Date] <= LastYearEndDate ) )

Please do gives a thumbs up if you find it helpfull

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    it says there is an error.

    • darkinvader_'s avatar
      darkinvader_
      Icon for Resolver I rankResolver I
      3 years ago

      Hi Anonymous ,
      Could you please send a Screenshot or description of the error

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        i have used a different method and it works fine now.. Thanks though