cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koray
Helper V
Helper V

Custom column: Add text to data for different

Hello,

 

I have a column that calculates the date data coming from Excel according to today.

 

Kalan Gün = DATEDIFF(Liste[Bir Sonraki Validasyon Tarihi],TODAY(),DAY)

 

koray_0-1616156408139.png

 

If the data in this column starts with "-" then "Days Left", if it doesn't starts with "-", I want to bring "Days Passed" text.

 

Like this:

koray_1-1616156925554.png

 

Thank you for help.

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@koray , Try a new column like

Kalan Gün =
var _1 = DATEDIFF(Liste[Bir Sonraki Validasyon Tarihi],TODAY(),DAY)
return
if(_1 <0, _1 & " Days Left" , _1 & " Days Passed")

View solution in original post

negi007
Super User
Super User

@koray 

 

you can create your column like below

 

Column=
var diff = DATEDIFF('Date'[Date].[Date],TODAY()-50,DAY)
return
if (diff<0,diff&"-Days Left",diff&" days Passed")

 

let me know if it works for you or not. thanks




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

View solution in original post

3 REPLIES 3
koray
Helper V
Helper V

Thank you both for your help.

negi007
Super User
Super User

@koray 

 

you can create your column like below

 

Column=
var diff = DATEDIFF('Date'[Date].[Date],TODAY()-50,DAY)
return
if (diff<0,diff&"-Days Left",diff&" days Passed")

 

let me know if it works for you or not. thanks




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

amitchandak
Super User
Super User

@koray , Try a new column like

Kalan Gün =
var _1 = DATEDIFF(Liste[Bir Sonraki Validasyon Tarihi],TODAY(),DAY)
return
if(_1 <0, _1 & " Days Left" , _1 & " Days Passed")

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors