Forum Discussion

ashish18's avatar
ashish18
New Member
1 year ago
Solved

Calendar Date not working with created date and resolved date

Hi Guys,  I am trying to get total open defect Vs closed defect per day from Source file. Source file has created on date and Resolve date. I want these both dates to behave with calender date. I h...
Need Help
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    ashish18 ,

    hey, I recreated the measures and everything you had, and I have no issues; it must be the DateTime in the Resolved Date, perhaps.

     

    The 9 likely represents the 9 missing Resolved Dates in the source I had.

     

    Check out my file and compare it with yours.

  • vojtechsima's avatar
    vojtechsima
    1 year ago

    ashish18 , thought so, good you found it. If you could please mark my answer as the solution to close the thread. Thanks

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
1 year ago

ashish18 hey, double check that all dates you use to build a calendar and the calendar itself it set to Date not Datetime.

  • ashish18's avatar
    ashish18
    New Member
    1 year ago

    HI vojtechsima  Thnaks for ur response.. Even if I change it to datetime,it still give same issue

    • vojtechsima's avatar
      vojtechsima
      Icon for Super User rankSuper User
      1 year ago

      ashish18 , Change it do DATE, not datetime. Otherwise, all seems good. If you have sample pbix file , you can share it through OneDrive/Google Drive.

      • ashish18's avatar
        ashish18
        New Member
        1 year ago

        HI vojtechsima   Sorry if I missed anything. DateTable already has Date

         
        DateTable =
        ADDCOLUMNS (
            CALENDAR (MIN('SourceFile'[Created on Date]), MAX('SourceFile'[Resolved])),
            "Year", YEAR([Date]),
            "Month", FORMAT([Date], "MMMM"),
            "MonthNumber", MONTH([Date]),
            "Weekday", FORMAT([Date], "dddd")
        )