How to calculate average of month without date colum

[Monisharisha]

How to calculate the average per month when there is no date column and the table has only customer Id,spend money , month ( string data type), category , payment type .

 

[Greg_Deckler]

@Monisharisha Well, depends on exactly what you want but if you want the average spend money per month it would be this:

Average Spend Money Measure = AVERAGEX( SUMMARIZE('Table',[Month],"__Value", SUM('Table'[spend money]) ), [__Value] )

[Monisharisha]

 

 

 

[Monisharisha]

No it is not working as expected .i can share you the dataset can u check on it and help me please 

[Monisharisha]

Challenge number 8 .  
it has all the table and data 

[AnalyticPulse · Accepted solution]

first create a separate date table  for the time intelligence functions to work,

then add calculated column for month in your date table, and  format it like the month column in your transaction data. make join based on month column. and use the time intelligence function to calculate the previous month total.

Follow this blog for more post about data analytics and visualization:

https://analyticpulse.blogspot.com/