Forum Discussion
AdministratorAges according to dates
Hi Syndicate_Admin ,
Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_AdminOk, I would attach a pbix where you can see that I calculate the age that users had according to selected date but I do not know how to attach it. What button is it? What I don't know how to do is then represent the number of people who were 14 years old, those who were 15... and so on in a single graph. I would have to put the calculated age measure on the Y axis but it won't let me. I must also calculate the median age of the different people but filtandro since the same person can have several rows in the excel origin and as it is now, each row counts me for the calculation of the median of the age.
SpoilerMiddle age = AVERAGEX(Demands,[Age at the end of selected date])Distinct Persons = DISTINCTCOUNTNOBLANK(Claims[codi_exp])
Age at the end of the selected date = DATEDIFF(SELECTEDVALUE(Demands[fecha_nacimiento]),MAX(Calendar[Date]),YEAR)Thank you very much in advance for your help.
Hi Syndicate_Admin ,
Please try to use Onedrive (or google) share links .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Syndicate_Admin