Forum Discussion

grzegorz32's avatar
grzegorz32
Frequent Visitor
5 years ago

The count function in Dax

Hello, I have the following functions written in Excel: = COUNTIFS ('70 '! $ P $ 2: $ P $ 691, "> =" & A235, '70'! $ P $ 2: $ P $ 691, "<" & A236) Which checks whether a machine cycle has occurred a...
amitchandak's avatar
amitchandak
Super User
5 years ago

grzegorz32 ,Can you share sample data and sample output in table format?

  • grzegorz32's avatar
    grzegorz32
    Frequent Visitor
    5 years ago

    Hi, Yes.

     

    I have a table that is clocking the time every 36 seconds. on its basis, I need to write a query in DAX which will check whether in the table:

    There is a cycle cycle in the long table.
    In short, it wants to check whether an operation is performed every 36 seconds ... or whether there are micro-stops.