Count distinct by month in a year (video game industry)

[Mayns]

Hi all,

I'm working for a video game company and i would like to create a graph to show me the number of distincts games released each month in a selected year. 

To make that i created a first measure to define how many games are released in the selected year and i applied this filter to my page 

 here you can see : Fresh Games : 886 during the fiscal year 2021-2022

Now i would like to see that per month but if i make a "Distinct count" on the game titles i have this : 

First of all, this is a cumulative bar chart because a game release in april will be sold also in may and after so it is normal but i would like to have the really distinct games by month... so i tried to make April = April ; May = May - April ; June = June - May ; .... but i didn't succeed.

Second point ; it is weird because at the end of the fiscal year 'March' , it should be 886 but i have 782 ... :'( 

Someone can help me on this ? Maybe i need to create a mesure to show the distinct games by months...

Thanks in advance 

[amitchandak]

@Mayns , You have Cumulative data , you need Cumulative .

You can get YTD

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"3/31"))

or

Using FY year and Month (March should be 12)

YTD= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[FY]=max('Date'[FY]) && 'Date'[FY Month] <= Max('Date'[FY Month]) ))

if data is already cumm , you can create a new column

new column =

var _max= sumx(filter(Table, [FY] = earlier([FY]) && [FY Month] = earlier([FY Month]) -1) , [Value])

return

[Value] - _max

https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...