Forum Discussion

Bhavana_PB's avatar
Bhavana_PB
Frequent Visitor
8 years ago
Solved

Day Function is not working properly

  Very simple calculated column I did. I have order date and I want to extract day out of that date. I wrote this  datepartDay = DAY(ListOfOrders[Order Date].[Date]) This is what I get. I...
Reports
  • Anonymous's avatar
    Anonymous
    8 years ago

    Bhavana_PB,

    Do you have duplicate values for the highlighted dates? If so, please select "Don't summarize" for the datepartDay column in table visual.


    Regards,
    Lydia

Bhavana_PB's avatar
Bhavana_PB
Frequent Visitor
8 years ago

Hi Anonymous

Thanks a lot, this is what exactly was happening.


Thank you
Bhavana