Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
10 years ago

Time Intelligence Functions (DAX)

Can I use Time Intelligence Functions (DAX) in Power BI?
Need Help
Show and Tell
pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
10 years ago

 Is it the table with only one column --dates ?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    pstanek Try this Measure... let me know

     

    pcena_bd_last30days =
CALCULATE (
    SUM ( movement[pcena] ),
    DATESINPERIOD ( movement[date], LASTDATE ( movement[date] ), -30, DAY )
)