Forum Discussion
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 ...
Hi
Effective start Effective End expected output
1 march 2023 31 march 2023 30 march 2023
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