Forum Discussion
Time Intelligence Functions (DAX)
Yes. You can use any DAX functions in Power BI.
Can you give me a hint ?
pcena_bd_last30days2 = CALCULATE(SUM(movement[pcena]); movement[datum]>NOW()-30; movement[datum] <= NOW())
I tried to rewrite this with function datesbetween, but It did not work.
pstanek In order to use time intelligence functions you need to have a date table related to your fact table. It would appear in your DAX function that you are referencing the same table.
Is it the table with only one column --dates ?
It can have as many columns as you like but it needs one column with an unbroken range of dates (i.e. every date within the range with no dates skipped). People frequently add other columns such as Month and Year in order to use those groupings in their visuals, but that depends on your goals with this.
Hi Pstanek,
According to your description, you need a moving sum for latest 30 days, right?
If that is the case, here is a blog which describes hwo to do it step by step, please refer to the link below to see the details.
[3 Month Moving Sum Units Sold] =
CALCULATE([Units Sold],
DATESINPERIOD(Calendar[Date],
LASTDATE(Calendar[Date]),-3, Month
)
)http://www.powerpivotpro.com/2013/07/moving-averages-sums-etc/
Regards,
Charlie Liao
