Forum Discussion
Helper VDAX: 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.
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.
Helper VIn case someone had some time to check my .pbix, do you have any solution? I think it has something to do with the date table but I can't find the problem.
Power ParticipantHi 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
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.