i am trying to fetch the count of data such as tickets created in last 24 hours in Power BI usingDAX

[Faeez]

I set up a date column and added two options if todays date (today) then Yes if not should pop up rather its not oving

[Faeez]

[moncx]

Can you give more context to your problem? How your data looks like, what have you done and what does not work? Does the filter not work when you apply 'if today' option?

[Faeez]

I am trying to build a report for a team where i am trying to fetch P1 incidents reported in last 24 hours.

can you assist with any troubleshooting step or query?

[moncx]

How does you data look like? Do you have only Date or dateTime? 

[Faeez]

If you see above these are the dates on which we got issues and here i am trying to implement a filter to get the count of tickets which we received in last 24 hours 

[Anonymous]

Hi, @Faeez 

Thanks for moncx's reply. You can try this dax to achieve your need.

Flag = IF( SELECTEDVALUE('Date'[Date]) >= (TODAY() -1) && SELECTEDVALUE('Date'[Date])<TODAY(),"Yes")

Counts = CALCULATE(COUNTROWS('Date'),FILTER('Date',[Flag] = "Yes"))

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Faeez]

could you please help me with creating a DAX query for getting count of tickets created in last 24 hours using the data given below?

Incident Number	Priority	Created	Work group	Issue description
INC-200000	1-critical	2024-12-12 00:28:00	Network L2	Network issue
INC-200001	1-critical	2024-12-12 00:28:00	DB L2	DB issue
INC-200002	1-critical	2024-12-12 00:28:00	Network L2	Network issue
INC-200003	1-critical	2024-12-12 00:28:00	DB L2	DB issue
INC-200004	1-critical	2024-12-10 00:28:00	Network L2	Network issue
INC-200005	1-critical	2024-12-11 00:28:00	DB L2	DB issue

[DataNinja777 · Accepted solution]

Hi @Faeez ,

To calculate the count of tickets created in the last 24 hours, you can use the following DAX measure:

Tickets_Last_24_Hours = 
CALCULATE(
    COUNTROWS('Table'),
    'Table'[Created] >= NOW() - 1
)

This measure counts the number of rows in the table where the Created datetime column is greater than or equal to 24 hours ago, as determined by the NOW() function. Replace 'Table' with the actual name of your table. Ensure the Created column is formatted as a datetime type for proper comparison. If you need a static calculation based on a specific reference datetime, replace NOW() with DATETIME(YYYY, MM, DD, HH, MM, SS).

Best regards,

[Faeez]

Could you also tell me how to get the count of last 72 hours using DAX and another requirement is how to get the data for those count of data from 24hours/72 hours?

[Faeez]

@DataNinja777  Thank you Very much, this query help me achieve the output. 

you are awesome.

[Anonymous]

Hi, @Faeez 

Of course, but what do you expect to achieve, you can bring out the effect you want.

Best Regards,
Yang
Community Support Team

[Faeez]

Hello @Anonymous 

i would like to achieve the count of tickets received in last 24 hours using the data i gave you.

I tried to run the DAX query you gave previously but i was getting error.

Could you try the DAX for the given data ?