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.
It gives me correct values
Did you try this formula
Column = VAR Priorday = CALCULATE ( MAX ( TableName[Week] ), FILTER ( ALL ( TableName ), TableName[Week] < EARLIER ( TableName[Week] ) ) ) RETURN DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( TableName, TableName[Week] = Priorday ) ) ) - 1
Could you show me the screenshot of your formula?
If your Weeks are simple dates with 7 days gap then this calculated column should work
Colum = VAR Priorday = PREVIOUSDAY ( TableName[Week] ) RETURN DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( TableName, TableName[Week] = Priorday ) ) ) - 1
Hi @sewaktamang
Please try with this minor modification (HIghlighted in RED below)
Colum = VAR Priorday = PREVIOUSDAY ( TableName[Week] ) RETURN DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( ALL ( TableName ), TableName[Week] = Priorday ) ) ) - 1
PREVIOUSDAY ( TableName[Week] )
THis is giving Empty Column
my mistake. PreviousDays do not exist since there are gaps in dates
Please use the revised formula. I provided above. It shall work hopefully
It is giving me date value 😞
Column
Friday, 29 December 1899 |
Saturday, 30 December 1899 |
Saturday, 30 December 1899 |
Saturday, 30 December 1899 |
Saturday, 30 December 1899 |
It gives me correct values
Did you try this formula
Column = VAR Priorday = CALCULATE ( MAX ( TableName[Week] ), FILTER ( ALL ( TableName ), TableName[Week] < EARLIER ( TableName[Week] ) ) ) RETURN DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( TableName, TableName[Week] = Priorday ) ) ) - 1
Could you show me the screenshot of your formula?
A small improvement to this formula so that you do not get -100% for firstweek/firstdate
HIghlighted in RED font below
Column = VAR Priorday = CALCULATE ( MAX ( TableName[Week] ), FILTER ( ALL ( TableName ), TableName[Week] < EARLIER ( TableName[Week] ) ) ) RETURN IF ( NOT ( ISBLANK ( Priorday ) ), DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( TableName, TableName[Week] = Priorday ) ) ) - 1 )
Hi @sewaktamang
My apologies.
Please use this formula
This will get you correct results
Column = VAR Priorday = CALCULATE ( MAX ( TableName[Week] ), FILTER ( ALL ( TableName ), TableName[Week] < EARLIER ( TableName[Week] ) ) ) RETURN DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( TableName, TableName[Week] = Priorday ) ) ) - 1
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |