Reply
Monisharisha
Regular Visitor

How to calculate average of month without date colum

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 .

IMG_9516.jpeg

1 ACCEPTED SOLUTION
AnalyticPulse
Super User
Super User

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/

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

@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] )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

IMG_9526.jpeg

IMG_9527.jpeg

IMG_9528.jpeg

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

Challenge number 8 .  
it has all the table and data 

AnalyticPulse
Super User
Super User

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/

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)