Let date show in different month then indicated by the date column using DAX

Anonymous — Thu, 18 Jun 2020 07:44:06 GMT

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

Re: Let date show in different month then indicated by the date column using DAX

Anonymous — Thu, 18 Jun 2020 08:06:04 GMT

Already found it. Thanx,

Use dateadd -4 in the measure

topic Let date show in different month then indicated by the date column using DAX in DAX Commands and Tips

Let date show in different month then indicated by the date column using DAX

Re: Let date show in different month then indicated by the date column using DAX