Forum Discussion

oliverome's avatar
oliverome
Regular Visitor
2 years ago
Solved

Distinguish in date notation depending on project status (planned/started)

Hi, I'm building a dashboard to do some project management. I'm looking to distinguish date notation in a table on my dashboard. Here's an example of what I'm looking for:     Status Start da...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi oliverome 

     

    You can try below calculated column expression.

     

     

    Column = IF('Table'[Status]="Started",FORMAT('Table'[Start date (current view)],"d-m-yyyy"),FORMAT('Table'[Start date (current view)],"""Week"" ww"))

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

     

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Hi oliverome 

 

You can try below calculated column expression.

 

 

Column = IF('Table'[Status]="Started",FORMAT('Table'[Start date (current view)],"d-m-yyyy"),FORMAT('Table'[Start date (current view)],"""Week"" ww"))

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

 

  • oliverome's avatar
    oliverome
    Regular Visitor
    2 years ago

    Hi! Thanks for your reply. I don't know where to put this expression - through 'create custom column' does not seem to work. Under 'calculated column' I get if-statements, but no way to format the output. 

    Can you show me a bit more of how you created this expression, and where you added it?

     

    Edited to add: Nevermind, I figured it out! Many thanks!