Hello, I am trying to replicate an excel formula into dax and am having some issues. Here is the excel formula: Excel: =if(start date <= current date, MIN((1/(End Date-Start Date+1)),1),0) I have not found a great way to replicate this. Thank you!

Anonymous Well, as a column that would be: IF( [start date] <= TODAY(), MIN(1/([End Date] - [Start Date] + 1),1), 1, 0 )

Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Hello,

I am trying to replicate an excel formula into dax and am having some issues. Here is the excel formula:

Excel: =if(start date <= current date, MIN((1/(End Date-Start Date+1)),1),0)

I have not found a great way to replicate this.

Thank you!

Greg_Deckler
2 years ago
Anonymous Well, as a column that would be:

IF( [start date] <= TODAY(), MIN(1/([End Date] - [Start Date] + 1),1), 1, 0 )