Forum Discussion
Dates mess
Anonymous
Adding a relationship between tables and creating calculations using those relationships will solve this issue. Here is a group of relationship blogs to help.
https://powerpivotpro.com/category/skill-areas/relationships/
Community ChampionAnonymous
*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/
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
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.
- kcantor
Anonymous
Adding a relationship between tables and creating calculations using those relationships will solve this issue. Here is a group of relationship blogs to help.
https://powerpivotpro.com/category/skill-areas/relationships/