Page-Level Filter by measure

[pstanek]

I would like to filter by NOW()-1, YTD, MTD and others , but I have many parameters, So I don´t want to create

CALCULATE( SUM( TABLE[COLUMN1];TABLE[DATE]=NOW()-1)

CALCULATE( SUM( TABLE[COLUMN2];TABLE[DATE]=NOW()-1)

CALCULATE( SUM( TABLE[COLUMN3];TABLE[DATE]=NOW()-1)

.

.

.

I use direct query most of time, so I can´t use time intekigence funtion. How will I do it without create the same measure multipletimes. I want one measure and use u in page level filter for example.

[GilbertQ]

Hi @pstanek

If I understand what you are trying to do is to create a page level filter based on a date?

If so you can use the relative date slicer in the May version of Power BI Desktop?

This will allow you to filter your data in your page based on a date.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/#relativeDateSlicer

[Anonymous]

An alternate method, should @GilbertQ's not be to your liking, is to create a calculated column which does a simple IF statement to check if the row is in the date filtered range or not.  Something like

inRange = IF(
	'Table'[Date] < Today(),
	1,
	0
)

You can set your filter to only show rows where the inRange = 1

[pstanek]

Can I use use relative slicer from certain date?

For example If I want to filter interval NOW -14 to NOW - 7 , I can´t use relative slicer. I can use relative slicer , if I want to filter NOW -7 to NOW.