Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dax for creating date column for specific dates.

Hello, Please anyone can tell me how can i create the dax column for date table as it will automatically add 1st date of every month  like eg:- Year & Month Identifier = {"01-January-2018","01-Fe...
CALENDER
Date
DAX
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Try this code to add a new table:

Table = 
filter(CALENDAR(date(2018,1,1),Today()),day([Date])=1)

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi

as mention in formula 

Table = 
filter(CALENDAR(date(2018,1,1),Today()),day([Date])=1)

in my dataset date field is not there.