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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to make parametric the New Calculate Column

I'm a very very beginner. I just need to create a new column where I want to calculate how many days passed from a date present in a column and the max date present in an another column. 

thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Yes, it works as expected and this solved my need. The question now becomes: if the anchorage date would be an "input parameter" and not an information stored in  column ?

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous ,  New column can not take slicer values. But you can have columns like

new column = datediff([date1],max([Date2]),day)

 

new column = datediff([date1],today(),day)

Anonymous
Not applicable

Yes, it works as expected and this solved my need. The question now becomes: if the anchorage date would be an "input parameter" and not an information stored in  column ?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.