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.
Hey Guys,
I'm trying to visualise a project buffer consumption where the timeline reaches from the project startdate to the project enddate. The problem is that i want to create the timeline-column with the "new column" operation using something like "datesbetween() etc."
Has anybody an idea how to tackle this problem?
greetings,
David
You may use DATEDIFF Function.
Column = DATEDIFF ( Table1[startdate], Table1[enddate], DAY )
Hello Sam,
using the Datediff function gives me back a column where every row contains the NUMBER of days between the two dates. What I need is a column containing every single date between the Start- and Enddate. e.g.: 01.01.2000 / 02.01.2000 / 03.02.2000...etc.
The Datesinbetween function seems to do the job, but i won't get it working 😕
You may add calculated tables.
Calendar = CALENDARAUTO ()
Table = GENERATEALL ( Table1, SELECTCOLUMNS ( DATESBETWEEN ( 'Calendar'[Date], Table1[startdate], Table1[enddate] ), "Date2", 'Calendar'[Date] ) )
Hey Sam,
That was the work around i allready did and made the screenshot of. I am trying to solve it only using the "new column"- formulas. There must be a way doesn't it?
greetings,
Dave
Hey Sam,
i just saw that i never attached the screenshot i spoke about.
Here you go:
but this still isn't the answer i',m looking for...
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |