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 Community,
I am trying to add an integer column and a date column (DATE_IN ) to get arrive a new column called Due Date.
Which formula can I use in Power BI?
Thanks in advance for your support!
Solved! Go to Solution.
@ss89 Just use + operator like [Date] + [Some Integer Column].
DAX Dates are decimal numbers where the integer portion is the number of days since December 30th, 1899 and the decimal portion is fractions of a day, like 1/24/60/60. So, just adding an integer to a date adds that many days to the date.
hi @ss89
As suggested by Greg, you can try to add a column like:
DueDate = [DATE_IN] + LOOKUPVALUE(...)
@ss89 Just use + operator like [Date] + [Some Integer Column].
DAX Dates are decimal numbers where the integer portion is the number of days since December 30th, 1899 and the decimal portion is fractions of a day, like 1/24/60/60. So, just adding an integer to a date adds that many days to the 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 |
---|---|
111 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |