Forum Discussion
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, withoute using filters.
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
1 Reply
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