Forum Discussion
rmeng
Helper II
5 years agoCalculate Growth from table
I have a table like this:
My measure are:
- # Score = AVERAGE('Table'[Value])
- # Score Education =
CALCULATE (
[# Score],
FILTER (
'Table',
'Table'[Section] = "Education"
)
) - # Score Establishment =
CALCULATE (
[# Score],
FILTER (
'Table',
'Table'[Section] = "Establishment"
)
) - Score Previous Month =
CALCULATE (
'SITE READINESS SECTION'[# Score],
DATEADD ( 'DIM CALENDAR'[Date], -1, MONTH )
) - Score Growth =[# Score]-[Score Previous Month]
When I add a table with measures and Archtype column the result is:
The result should be like this :
Can you help me with this?
Thanks
2 Replies
- amitchandak
Super User
rmeng , Hope you are taking date from date table in the visual and date in the table does not have timestamp.
Also, the date table is marked as a date table. https://www.youtube.com/watch?v=OBf0rjpp5Hw
- rmeng
Helper II
Yes I Have a Dimension calendar date column is a date.
Thanks