Date calculation

[Anonymous]

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

[DataVitalizer]

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

[ryan_mayu]

@Anonymous 

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

[Anonymous]

Hi

Effective start    Effective End      expected output

1 march 2023   31 march 2023    30 march 2023

[DataVitalizer]

Hi @Anonymous 

To reach this result add a calculated column :

expected output='MyTable'[Effective End ]-DAY('MyTable'[Effective start])

If you are trying to calculate the difference between Start and end date you should use this code instead

Difference= DATEDIFF('MyTable'[Effective start],'MyTable'[Effective End],DAY)

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[ryan_mayu]

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