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.
SpartaBI Thanks for your answer, I understand now how to use it ! 7
It works perfectly !
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 🙂