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 friends. Could help me with the following question ? I'm trying to create a custom column in power query with the following parameter . I have 2 columns , column A that has dates and the B column has numbers , I would add the column (data) + Column B (number) and the result would come as a date. Example: Column A = 01.01.2016 ( Date ) Column B = 10 (number) Sum of Two would = 01.11.2016
Solved! Go to Solution.
Hi,
You can add a custom column with this formula:
Date.AddDays([A], [B])
Hi,
You can add a custom column with this formula:
Date.AddDays([A], [B])
Thank you, this was exactly what I needed, and it worked perfectly!
Thanks for the solution
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |