Forum Discussion
Exclude a column from a filter
- 4 years ago
Anonymous In addition to your question, I saw how you used the data column inside the DATESINPERIOD function. This is not how you should do that. Either you have a dim dates you created or you use the autodate time table.
For simplicity, let's say you use the autodate time, than your measure is:DIVIDE( CALCULATE ( SUM ( 'Google analytics'[Number of sessions] ) * SUM ( 'Google analytics'[Average time per session] ), DATESINPERIOD ( 'Google analytics'[Date].[Date], FIRSTDATE ( 'Google analytics'[Date] ), -1, MONTH ) ), SUM ( 'Google analytics'[Cumulative number of session each week] ) )Pay attention to the version I used:
'Google analytics'[Date].[Date]
Also, you don't need the ALL argument as you play with filters on the date table anyway.
Anonymous In addition to your question, I saw how you used the data column inside the DATESINPERIOD function. This is not how you should do that. Either you have a dim dates you created or you use the autodate time table.
For simplicity, let's say you use the autodate time, than your measure is:
DIVIDE(
CALCULATE (
SUM ( 'Google analytics'[Number of sessions] )
* SUM ( 'Google analytics'[Average time per session] ),
DATESINPERIOD (
'Google analytics'[Date].[Date],
FIRSTDATE ( 'Google analytics'[Date] ),
-1,
MONTH
)
),
SUM ( 'Google analytics'[Cumulative number of session each week] )
)
Pay attention to the version I used:
'Google analytics'[Date].[Date]
Also, you don't need the ALL argument as you play with filters on the date table anyway.
SpartaBI Thanks for your answer, I understand now how to use it ! 7
It works perfectly !
- SpartaBI4 years ago
Community Champion
Anonymous my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂