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())
krishb1414's avatar
krishb1414
Icon for Helper III rankHelper III
3 years ago

Hi Anonymous  You can try this measure

SPLY INVoiced = 
VAR MaxDate = Month(Today())
VAR MinDate = Month(Today()) - 12
RETURN
CALCULATE(
    [Invoice Line Total],
    Filter(Date, 
           'Date'[Date] >= MinDate && 'Date'[Date] >= MaxDate
))


If it solves your query, Please accept it as a solution. so that someone will get help from this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    thanks krishb1414  , I got the answer