Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Calenderauto on specific date field

So I have a calenderauto via DAX: Now my data has 3 date fields. Fields like Manufacturing Date and Use before date are messing up my min and max date that I want to have. I want the calende...
  • amitchandak's avatar
    amitchandak
    4 years ago

    rpinxt , Then you can use of the calendar is best. auto-calendar has a different purpose

     

    I usually force those date to go start and end of the year

     

     

    CALENDAR(eomonth([MinRepDate], -1* Month([MinRepDate])) +1 ,eomonth([MaxRepDate] , 12 -1* Month([MinRepDate]) ))

     

     

     

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
4 years ago

Thanks amitchandak , but yes this code works.

But as said there are 3 date fields in my data.

So this code finds the first date and the last date of all dates in these 3 fields.

I wanted it to take only the dates of 1 specific date field and autocalendar on that field only and not the other 2.

 

But I now solved it likes this without autocalendar:

Dim_Date =
ADDCOLUMNS(
CALENDAR([MinRepDate],[MaxRepDate]),
"Year", YEAR([Date]),
"Quarter", FORMAT([Date],"\QQ"),
"Quarter Nr", QUARTER([Date]),
"Month", FORMAT([Date], "mmmm" ),
"Mth", FORMAT([Date], "mmm" ),
"Month Number", MONTH([Date]),
"Week Number", WEEKNUM([Date]),
"Week Day", FORMAT([Date], "DDD"),
"Week Day Nr", WEEKDAY([Date], 2),
"Period", FORMAT([Date], "YYYY-MM"),
"Period2", FORMAT([Date], "YYYY-MM")
)
So I made a Min and Max date on that 1 date field it al want it on.
Guess this is the best way.
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

rpinxt , Then you can use of the calendar is best. auto-calendar has a different purpose

 

I usually force those date to go start and end of the year

 

 

CALENDAR(eomonth([MinRepDate], -1* Month([MinRepDate])) +1 ,eomonth([MaxRepDate] , 12 -1* Month([MinRepDate]) ))