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

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Yes. You can use any DAX functions in Power BI.

    • 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.