Forum Discussion

DouglasWatkins's avatar
DouglasWatkins
Frequent Visitor
4 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

This sounds pretty straightforward. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

  • DouglasWatkins's avatar
    DouglasWatkins
    Frequent Visitor
    3 years ago

    I've tried a few things but the issue with the other answers working for me is my date column is not a complete set of dates.  It seems all the power bi formulas require a complete January 1 to December 31 calendar.  My data doesn't have that and I can't edit it because the data will updated regularly.

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi DouglasWatkins ,

      Have you tried my solution, is it helpful?

      Best Regards,
      Community Support Team _ kalyj

      • DouglasWatkins's avatar
        DouglasWatkins
        Frequent Visitor
        3 years ago

        I tried it.  It seemed promising but it didn't work.  Thank you for trying.