Forum Discussion

RichardT_78's avatar
RichardT_78
Icon for Helper I rankHelper I
6 years ago
Solved

Elapsed Days

  Hi I am new to power BI    I have created a flow to update a power BI dataset and then created a report from it. All has worked well.    My time stamp is  shown as: 03/27/20 12:33:46 PM from ...
General Comment
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi RichardT_78 

     

    You can create a measure like 

     

    Measure = DATEDIFF( SELECTEDVALUE( table[column] ), TODAY() or NOW(), DAY )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi RichardT_78 

 

You can create a measure like 

 

Measure = DATEDIFF( SELECTEDVALUE( table[column] ), TODAY() or NOW(), DAY )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • RichardT_78's avatar
    RichardT_78
    Icon for Helper I rankHelper I
    6 years ago

    Perfect and very simple thanks.