Forum Discussion
Current data by month
Hi Bohdan_H
Try the following suggestion.
1.The date table have no relationship with data table
Then create a column in data table
Max_level = MAXX(FILTER('Table',[Name]=EARLIER('Table'[Name])&&EOMONTH([Date],0)=EOMONTH(EARLIER('Table'[Date]),0)),[Level])Then create a new measure
Measure = CALCULATE(SUM('Table'[Level]),FILTER('Table',EOMONTH([Date],0)<=EOMONTH(MAX('Table 2'[Date]),0)&&[Level]=[Max_level]))Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
I want that when selecting any month in the filter, it shows me the data that was recorded last. That is, if we choose December, and for the person in July level 3 was recorded, and in September level 4, it will show level 4. If we choose August, it will show level 3 because it was the last one entered.
Hi Bohdan_H
Try the following suggestion.
1.The date table have no relationship with data table
Then create a column in data table
Max_level = MAXX(FILTER('Table',[Name]=EARLIER('Table'[Name])&&EOMONTH([Date],0)=EOMONTH(EARLIER('Table'[Date]),0)),[Level]) Then create a new measure
Measure = CALCULATE(SUM('Table'[Level]),FILTER('Table',EOMONTH([Date],0)<=EOMONTH(MAX('Table 2'[Date]),0)&&[Level]=[Max_level]))Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Thank you very much!
And the last question
Is it possible to make it so that it does not display the sum of the levels in the chart, but the number of those levels? for example, 4 levels are 8, 1 level is 1, etc.?
And to display not all levels in the graphics. And the last levels are precisely by "Name", because unic Name is less than 16