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 am getting wrong days. 

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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