Hi all,
I have created the following measure for my dashboard
Correctie bijboeking = CALCULATE(SUM(Conceptregels[Regelbedrag]),
FILTER(Conceptregels,Conceptregels[Type verwerking] = "VD"),
FILTER(Conceptregels,Conceptregels[Datum] = DATE(2020,1,16)))
Which gives me the values I need, exept in the dashboard I am using this measure for has a MONTH slicer. And I need this measure to give me these values when i select month May. Because of the data model the data shows up in Januari according to the link between date column and date table.
Is there a way to set the date 4 months in the future for this measure using DAX?
PS. I have created an extra column using the querie editor which gives me the date + 4 months but and used USERELATIONSHIP to link to this column. This works, but I do not really like it because this gives me a lot of extra data which I do not need. As I only need the month +4 for this specific measure and not for the entire transaction table.
,
Hope you can help me
