Forum Discussion
Make A Formula With Dates.
I have an Excel file I loaded into the program. There are 2 columns that I need to use to create something. I need to count the number of IDs in each day. Each day could be written in several rows...
I tried yours but it's not working. I think the issus is that my data table doesn't have a complete date range of January 1st to December 31st.
lbendlin
Super User
Super UserIt doesn't need to. What needs to have a complete range of dates is the Calendar table in your data model. If you don't have that then you need to add one.