Today function evaluates for every date

[bumoverflow]

Hey

I have simple table

What I want to is to compare Planned Deployment Date with todays date using TODAY() function. Unfortunatelly the expression evaluates for every day behind period column resulting in:

As you can see index is beaing repeated multiple times for every day of the month from period column. How can I avoid it and leave number of rows as it was?

Period column comes from Calendar table and connects to the fact table with * to 1 relation

[some_bih]

Hi @bumoverflow not sure, where did you implement your TODAY () function part - in Power Query or ... not sure how you got "explosion" of dates.

One option, if you need TODAY() to calculate something, you could use as VAR variable and compare it on row basis (like in Excel)