SPLY as Date for Visual Filter

[cn4422]

Hello,

I have created the following DAX measure that calculates SPLY for a specific value and that works just fine.

Verarbeitete Anfragen AT SPLY =

VAR dateRange = DATESBETWEEN('Datum'[Date], MIN(Datum[Date]),MAX(Datum[Date]))

Var dateRange2 = Sameperiodlastyear(dateRange)

RETURN

CALCULATE([Summe APF Status LH Verarbeitete Anfragen AT],

ALL('Datum'),

dateRange2

)

My question now is, if it is possible to write a DAX measure that can be used as a date-filter for a visual?
So basically the above code, without the calculate part.

Or do I somehow have to build this within my date table?

Thx in advance for your help! 😊

[ahadkarimi]

Hi @cn4422, create a calculated column, if you encounter any issues, let me know.

IsSPLY = 
VAR dateRange = DATESBETWEEN('Datum'[Date], MIN('Datum'[Date]), MAX('Datum'[Date]))
VAR dateRangeSPLY = SAMEPERIODLASTYEAR(dateRange)
RETURN
IF(
    'Datum'[Date] IN dateRangeSPLY,
    1,
    0
)

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!

[cn4422]

Hi,

@ahadkarimi could you peharps have one more look at my question on how to fix this?

Thank you!

[cn4422]

Hi,

thx for your reply!

I've created a column:

IsSPLY Spalte =

VAR dateRange = DATESBETWEEN('Datum'[Date], MIN('Datum'[Date]), MAX('Datum'[Date]))

VAR dateRangeSPLY = SAMEPERIODLASTYEAR(dateRange)

RETURN

IF(

    'Datum'[Date] IN dateRangeSPLY,

    1,

    0

)

and implemented it as a Filter for a visual (diagram), but the date doesn't change for the visual.

Do I have to set the format for the created column to "date"?

Or adjust something else?