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
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