Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Community Champion
Community Champion

@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
Community Champion
Community Champion

@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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors