Forum Discussion

ashish18's avatar
ashish18
New Member
10 months 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
    10 months 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
    10 months 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
10 months 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
    10 months 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
      10 months 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
        10 months 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")
        )