Forum Discussion
How to create a Daily report?
I currently have a few report pages that show the analytics of tickets in the company. In the current business we have tickets coming through every day.
I'm trying to create a page for daily reports so that it only shows tickets coming through on that exact day starting from 12 AM until the next 24 hours. Here is one example I have below (with the organisations deleted for privacy reasons) that shows every ticket in the organisation from each account. Now I want this to show each ticket in the organisation from each account on the current day instead.
Each ticket in the table that I'm using for the report has a Created Time column which indicates when the ticket was created as shown below:
So the main question, is there a measurement that can be added which makes a specific visual only show data on the current day that data was created? Thank you.
Hi,
in the measure,
ALL ( RequestDetails ) => removes all filters in the table.
please try to replace the above with the below.
ALL ( RequestDetails[CreatedDateTime] ) => removes the filter only in the specific column
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
8 Replies
Hi, Anonymous
You can restrict the result of your current measure by adding Calculate function & Filter function with date range to the current measure.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/Hello Jihwan_Kim thank you for the reply.
The only issue with the quick measurement is that it requires you to input a specific day of the month, rather than current. For example below:Sadly I can't find a current day for the measure.
Hi, Anonymous
Thank you for your feedback.
Instead of using the Quick Measure Function, how about trying to write by yourself?
I am not quite familiar with using the Quick Measure Function, because I did not try to use it....
You can use TODAY() function when you write the measure by yourself.
Try to write something like below.
Newmeasure =
CALCULATE (
[your measure],
FILTER (
ALL ( DateTABLE ),
[datecolumn]
>= TODAY () - 1
&& [datecolumn] <= TODAY ()
)
)Or, if it is OK with you, please share your sample pbi file, then I can try to come up with a more accurate measure.
thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/