Forum Discussion

pstanek's avatar
pstanek
Post 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
Post Patron
10 years ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

  • pstanek's avatar
    pstanek
    Post 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
        Community 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 )
)