Forum Discussion
12 month sum vs time filter
Hi,
I know that this topis was discussed many time but I am struggling with this problem.
I use data from ContosoRetailDW base as a demo, I would like to built measue calculatin sum of last 12 months ( currrent inculded )
I would also to present this data in 12 month range visuals beteween max date ( set manually ) - 12 months.
I have created a measure like this, with ALL function to be able to see proper SUM while using Date filter.
3 Replies
- v-yulgu-msft
Microsoft Employee
Hi Marcin,
It would be better that you can share the sample .pbix file for check. Do mask sensitive data before uploading.
Regards,
Yuliana Gu
- Marcin
Helper V
Hi,
How can I publish file here I also asked ?
Should I use external disk service to share file ?
As I mentioned I used data from ContoRetailDW ( Microsoft demo db ) so there is no need to mask any data.
Marcin
- Marcin
Helper V
Hi v-yulgu-msft
I used a blob storage:
https://powerbidemobi.blob.core.windows.net/demofiles/Contoso_demo.pbix