Hello all, I was looking for a way to create a calculated column that auto calculate the duration between dates in a date column called orderdate, with a filter of another column let’s call it Product. I composed the following expression: ByAymanProductFlowDays = var currentproduct=Sales[Product…

Hi @Ayman . Perhaps the techniques shown in this pattern or it’s subsequent discussion could help. Good luck. Greg [image] Previous Row Value DAX Calculations Often in a Power BI visual one wants to get the value from the previous row to use in a calculation in the current …

Subtract dates in the same column and return zero in case of the identical date values

DAX DAX Calculations

Greg November 30, 2020, 7:44pm 2

Hi @Ayman. Perhaps the techniques shown in this pattern or it’s subsequent discussion could help. Good luck. Greg

1 Like