cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gooranga1 Senior Member
Senior Member

Re: DAX: Previousmonth / parallelperiod / dateadd doesn't work

Hi @RemiAnthonise,

 

It looks like it's the TRansactionDate in your ProjectPostTransViews as it's a datetime field with a time of 12:00:00 midday. So when you link the Calendar table to it it will return no values as these are just the date that will assume midnight.

 

Create a new column in the ProjectPostTransViews table like;

 

TransactionDateOnly = date(year(ProjectPostTransViews[TransactionDate]),month(ProjectPostTransViews[TransactionDate]),DAY(ProjectPostTransViews[TransactionDate]))

then join on that.

gooranga1 Senior Member
Senior Member

Re: DAX: Previousmonth / parallelperiod / dateadd doesn't work

And you will need to change what you grouping by in your matrix. So either create a new column on Calendar that is "maand nummer" or group by Jaar and Maand from Calendar.

 

CapturePeriod.PNG

Re: DAX: Previousmonth / parallelperiod / dateadd doesn't work

@gooranga1 Yes, this did it! Thanks a lot, you made my day.