Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 .
Solved! Go to 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:
@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] )
No it is not working as expected .i can share you the dataset can u check on it and help me please
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:
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
27 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |