Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dates mess

Hi, I have a table with several dates columns that I need to use. But I'm not getting the results I want. I've created a dates tabel, and created a relationship between the dates columns that I nee...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi kcantor  and thanks for contributing!

 

When counting all the candidatesID, i get 2845, or 1532 when using distinctcount.

 

Candidates Added = COUNT(Assignments[CandidateID])

But when adding the dates, I get some issues. Days does not work for me, I get an error. I need to use day.

Candidates Added Last 30 = CALCULATE([Candidates Added]; DATEADD(Dates[Date]; -30; DAY))

Still, I get 2845 from that ones as well.

 

 

 

kcantor's avatar
kcantor
Community Champion
7 years ago

Anonymous 

     *When counting all the candidatesID, i get 2845, or 1532 when using distinctcount.

Which number is correct?My assumption would be that distinct would give you the correct number. 

     *Days does not work for me, I get an error. I need to use day.

Yes, sometimes when typing in this forum I use the plural because I get in a hurry. Sorry, my bad.

 

If you use distinct count and DAY and put the month on the columns, does the number for last 30 day give you the same number as the distinct count for the previous month? (Which makes me question if you want month over month shuold we use -1, MONTH in the calculation instead)

Can you share any data or a file?

Also, have you used this resource before? It may be a better method for you.

https://powerbi.tips/2016/07/measures-month-to-month-percent-change/

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    kcantor 

    1532 is correct. When I get the dates correct, I'm going to match it with the ID in another table.

     

    I could share the file with you in a private message? And we can share the solution here if we find it :)

    • kcantor's avatar
      kcantor
      Community Champion
      7 years ago

      Anonymous 

      You can share the file with me in a private message or if you have a link to a drop box you could share the data that way. I am always happy to help.