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

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")
    )
    • vojtechsima's avatar
      vojtechsima
      Icon for Super User rankSuper User
      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.

      • ashish18's avatar
        ashish18
        New Member
        10 months ago

        Hi vojtechsima Really appreciate ur help. It was a minor mistake...Resolved date in sourcr file was dateTime type.I changed it to Date and it worked now. 🙂  Thanks Again!!