Forum Discussion
Solved
2 date fields in different table
Hi everyone, I am new to Power BI and I will need some help here. I have 3 tables where one is a middle one and the two others has the full data. In the first table I have historical data and in ...
having a calendar table makes your life much easier (because you get to use the time intelligence functions)
you can do those calculations without it but you'll have to write a bit more
look here at this link provided by Matt
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
Sorry for the picture, for that metrics I am not using any measures, hope that screenshot is better
Maybe one of those is a cumulative/running total? Why is the difference so much?
Try creating Runing Totals for each like so
Forecast RT = CALCULATE ( SUM(Table[Forecast], FILTER(ALL(Table), Table[Date] <=MaX(Table[Date]) ) )
Actual RT = CALCULATE ( SUM(Table[Actual], FILTER(ALL(Table), Table[Date]<=MAX(Table[Date]) ) )