Forum Discussion

rodneyc8063_1's avatar
rodneyc8063_1
Helper V
7 years ago
Solved

TODAY() - Measure vs Calculated column differences?

Pardon the question - But I am still learning the ropes with Power BI   I just came across something that Im not sure why its happening   Very simple - I created a new table and a new calculated ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi rodneyc8063_1 

    Based on my experience, use "TODAY( )" in a calcuated column will get a columns show today's date, this would not change everyday dynamically.

    Look my example,

    Create a new table by this formula (Modeling tab->New table)

    Table = CALENDAR(DATE(2019,3,20),TODAY())

    Then Modeling tab->New column, enter the fomula

    Column = TODAY()

     

    But your test table is werid.

    Maybe you use the wrong method to test.

    Please test as i do above, then you will see the correct result.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi rodneyc8063_1 

Based on my experience, use "TODAY( )" in a calcuated column will get a columns show today's date, this would not change everyday dynamically.

Look my example,

Create a new table by this formula (Modeling tab->New table)

Table = CALENDAR(DATE(2019,3,20),TODAY())

Then Modeling tab->New column, enter the fomula

Column = TODAY()

 

But your test table is werid.

Maybe you use the wrong method to test.

Please test as i do above, then you will see the correct result.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.