topic Re: i am trying to fetch the count of data such as tickets created in last 24 hours in Power BI usingDAX in DAX Commands and Tips

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

Faeez — Wed, 11 Dec 2024 11:29:35 GMT

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

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

moncx — Wed, 11 Dec 2024 11:45:10 GMT

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?

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

Faeez — Wed, 11 Dec 2024 12:15:28 GMT

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?

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

moncx — Wed, 11 Dec 2024 13:59:42 GMT

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

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

Faeez — Wed, 11 Dec 2024 14:47:47 GMT

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

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

Anonymous — Thu, 12 Dec 2024 02:49:09 GMT

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

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

Faeez — Thu, 12 Dec 2024 13:00:53 GMT

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

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

Faeez — Thu, 12 Dec 2024 13:01:47 GMT

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

Anonymous — Fri, 13 Dec 2024 03:07:56 GMT

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

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

Faeez — Fri, 13 Dec 2024 12:44:58 GMT

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 ?

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

DataNinja777 — Sun, 15 Dec 2024 14:29:58 GMT

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,

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

Faeez — Mon, 16 Dec 2024 08:56:47 GMT

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

you are awesome.

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

Faeez — Tue, 17 Dec 2024 13:30:01 GMT

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?