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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Mahesh450
New Member

Age calculation

I have a sample table, in that i sales id i need to create the age for the sales id's as per the status

if the status is open

From "Created Date" till Today  ; If CLOSED (WON or LOST)  From "Created Date" till "WonLostDate"

 

kindly help me on this 

 

need to write a measure

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Mahesh450 Maybe:

Column = 
  SWITCH(TRUE(),
    [Status] = "Open", ( TODAY() - [Created Date] ) * 1.,
    [Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1.
  )

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@Mahesh450 Maybe:

Column = 
  SWITCH(TRUE(),
    [Status] = "Open", ( TODAY() - [Created Date] ) * 1.,
    [Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1.
  )

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors