Forum Discussion
Advocate IIDate multiplications
What is the reason, that you can!t get it to work?
By the way, what is the purpose to do this data transformation? Why you need this column?
Pavel
Solution Specialistinescosta so you want to get the date table, which will have dates between the lowest date InicioProjeto and highest date FimProjeto? If so, then use CALENDAR(MIN(Table[InicioProjeto]);MAX(Table[FimProjeto]))
Regards.
Pavel
inescostahttp://community.powerbi.com/t5/Desktop/Getting-all-dates-between-2-dates/m-p/61211/highlight/false
this is what I am trying to get...but I just can't seem to do it.
Using calendar() it will give me a different table, but then I need to associate values from the tables that I am using to that one.
What is explained in that post is perfect but I can't get it to work.
thank you
- PavelR
What is the reason, that you can!t get it to work?
By the way, what is the purpose to do this data transformation? Why you need this column?
Pavel
- inescosta
The column [quant] has the number of hours I can use in a particular project. the columns with the dates are the beginning and the end of the project. What I want in the end is a measure that gives me the nr of hours I can use per year in that particular project.
So this is what I am thinking:
1-I calculated how many days are between the two dates: column [nrdiasProjeto].
2-I divided the [quant] per [nrdiasProjeto] that gives me the average nr of hours I can use per day: column:[tempomediodia]
3- Know I would need a table with all the days between those dates and each day would have the average nr of hours allocated to them,
this way I coul them sum them by civil year.