Forum Discussion

bumoverflow's avatar
bumoverflow
Frequent Visitor
2 years ago

Today function evaluates for every date

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

Need Help

1 Reply

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    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)