Forum Discussion
Post ProdigyValues are not grouped in column
Hello,
I've created "Age" out of date and when I want to expand values in the "Data" view, I dont have grouped so its like "0", but all of the zero's are listed. Is it something of which I should be worried? Or just let it be
Seems like after quite some time it started to work normally..
8 Replies
PbiuserrSeems like after quite some time it started to work normally..
- jdbuchanan71
Super User
First thing that comes to mind, is the date column you are using to calculate the age actually a Date/Time with time values on it? If so, I think that might be causing your problem. It's not really 20 different '0' values, it's
0.1234646
0.6642364
0.8913989
etc...
Format your date field as Date/Time and post a screen shot and also share the formula you used to calculate the age so we can see it.
- Pbiuserr
Hi mwegener jdbuchanan71
The column I use as an reference is date type. I was thinking same about 0.4874 but I did it several times and it always worked - so out of column with dates I do new column -> Date -> Age, then Duration -> Total Years and then round down, so it suppose to be rounded to 0- mwegener
Most Valuable Professional
Strange, we would have to look at it in more detail with an example. Can you provide an example PBIX?
- Pbiuserr
I wanna group it and use it as axis
- jdbuchanan71
If you format the age field as decimal, are they actually 0?
