Forum Discussion
Create and keep COUNT data record into calendar
Hi Everyone,
Good day. I would like to seek help on how can I create a daily or monthly record in power bi. I am using IF statement that if the date is TODAY() count the column. My problem is my formula does not keep a record of the previous days count, it only shows todays data.
Here is my data. I want to have a record of the daily count. Thanks in advance for the help.
4 Replies
Hi Bogz ,
According to your statement, I think you want to calculate the count by date. If you want want to have a record of the daily count, you don't need Today() and IF().
Firtstly, Today() will return today‘s date. For example, today is 2023/1/16, so today will only return 2023/1/16. So your code will only return the count on 2023/1/14.
I think there should be a relationship between 'Security Concept' and 'Date' tables.
Count = COUNT('Security Concept'[Asset Name])Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry for the lack for information and if its not clear. I actually wants to have an inventory of the daily count of Security Concept [Asset Name]. I manage to achieve it by using power automate to export the daily data count to excel then use it back to power bi. Thank you so much for the reply. I will share my solution once completed.
- Ashish_Mathur
Super User
Hi,
Your question is not clear. Share some data, describe the question and show the expected result.
Sorry for the lack for information and if its not clear. I actually wants to have an inventory of the daily count of Security Concept [Asset Name]. I manage to achieve it by using power automate to export the daily data count to excel then use it back to power bi. Thank you so much for the reply. I will share my solution once completed.
