Forum Discussion

giorgi_lommidd's avatar
giorgi_lommidd
Helper I
7 years ago
Solved

Using DAX to make Visual level Filter

Hi All,  I have table with some values on Y axis and  Date on X axis.  Date ranges from dtStart to dtEnd . The data range changes dynamically.  I need to show data only for year = year(dtEnd) -1, wi...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, giorgi_lommidd 

    You could add a conditional in your formula

    for example:

    Measure = var lastenddate=CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table')) return
CALCULATE(SUM('Table'[Value]),FILTER('Table',DATEDIFF('Table'[Date],lastenddate,DAY)>365))

    Result:

    here is demo pbix, please try it.

    If not your case, please share a simple sample pbix file and your expected output.

     

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, giorgi_lommidd 

You could add a conditional in your formula

for example:

Measure = var lastenddate=CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table')) return
CALCULATE(SUM('Table'[Value]),FILTER('Table',DATEDIFF('Table'[Date],lastenddate,DAY)>365))

Result:

here is demo pbix, please try it.

If not your case, please share a simple sample pbix file and your expected output.

 

 

Best Regards,

Lin