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 , 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!!

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