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())
Anonymous's avatar
Anonymous
Not applicable
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())