Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Date calculation

Hi

Can any one please help me on how to calculate date difference from effictive start and effective end dates in DD/MM/YYYY format to use as date hierarchy filter 

 

Effective start    Effective End      expected output

1 march 2023   31 march 2023    30 march 2023

 

 

 

 

 

Need Help

5 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    Anonymous 

    what's the epxected output based on the sample data you provided?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi

       

      Effective start    Effective End      expected output

      1 march 2023   31 march 2023    30 march 2023

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        3 years ago

        is the expected output one day earlier than the effective end?

         

        Column = 'Table'[EffectiveEnd]-1
         
        you can you go to Model view and set the date format
         
  • DataVitalizer's avatar
    DataVitalizer
    Super User
    3 years ago

    Hi Anonymous 

    If you are trying to change the columns display format you can do it by selecting your columns and from Column Tools you can change Dates formats

    Otherwise please provide more details in case you have a different need.

     

    Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
    Was this exchange helpful? A kudos 👍 would be appreciated