Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
105 | |
88 | |
74 | |
67 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |