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.
Hello PowerBI users
I have a date column and I want to create a new column based on that date. The new date (in the new column) would be minus 25 months from the existing column.
Thoughts?
Kind regards
Ray
Solved! Go to Solution.
Hi @rayinOz ,
To use dateadd function, we should create a calendar table in advance and create relationship between tables.
calendar = CALENDAR(DATE(2016,01,01),DATE(2019,12,31))
Column = DATEADD('calendar'[Date],-25,MONTH)
To use EDATE as @Ashish_Mathur metioned, we can get the excepted result without calendar table.
pre = EDATE('Table'[date],-25)
Hi @rayinOz ,
To use dateadd function, we should create a calendar table in advance and create relationship between tables.
calendar = CALENDAR(DATE(2016,01,01),DATE(2019,12,31))
Column = DATEADD('calendar'[Date],-25,MONTH)
To use EDATE as @Ashish_Mathur metioned, we can get the excepted result without calendar table.
pre = EDATE('Table'[date],-25)
Hi,
Try this calculated column formula
=EDATE(Data[Date],-25)
Hope this helps.
Dateadd should allow you to do that. Give interval negative
https://docs.microsoft.com/en-us/dax/dateadd-function-dax
Hello @rayinOz
Give this a try.
Column = DATE ( YEAR ( 'Date'[Date] ), MONTH ( 'Date'[Date] ) -25, DAY ( 'Date'[Date] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |