Forum Discussion
Helper IIIVisual to show data change in time
Hi, fabiomanniti
If you don't process the data in advance on the desktop, you won't get your desired results directly through the visuals.
Maybe you can try the following methods.
Column:
last date = DATEADD('Table'[Subscription date],-1,MONTH)Measure:
Difference = VAR N1 =CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), [Country] = MAX ( 'Table'[Country] ) && [ID] = MAX ( 'Table'[ID] ) ) ) VAR N2 =CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), [Country] = MAX ( 'Table'[Country] ) && [Subscription date] = MAX ( 'Table'[last date] ) ) ) RETURN DIVIDE ( N1 - N2, N2 )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIIYes, these tools per se look good but, for I understood, I must already have data worked on Desktop...
I mean: if I only have this table
| ID | Subscription date | Country |
| 1 | 01/01/2019 | IT |
| 2 | 02/01/2019 | FR |
| 3 | 03/01/2019 | US |
Can I know ONLY with a visual the id counting for each Country and each month (for only the last n months) and see the changing ratio compared to the previous month?
If I can do it with those visual then I think I didn't understand how
Community SupportHi, fabiomanniti
If you don't process the data in advance on the desktop, you won't get your desired results directly through the visuals.
Maybe you can try the following methods.
Column:
last date = DATEADD('Table'[Subscription date],-1,MONTH)Measure:
Difference =
VAR N1 =CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( ALL ( 'Table' ),
[Country] = MAX ( 'Table'[Country] )
&& [ID] = MAX ( 'Table'[ID] ) ) )
VAR N2 =CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( ALL ( 'Table' ),
[Country] = MAX ( 'Table'[Country] )
&& [Subscription date] = MAX ( 'Table'[last date] ) ) )
RETURN DIVIDE ( N1 - N2, N2 )
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.