Forum Discussion
Post PatronAdd summarize columns on previous or today
Hi
I want to bring columns in from another table and then filter on today or previous month.
I have the columns showing but the calendar filter is not working, any ideas please? Ross
Hi
Worked it out by bringing in Date from headcount table rather than calendar table and using LASTDATE
4 Replies
v-lili6-msftCommunity Support
HI rosscortb
If this formula could meet your requirement:
Org Chart = SUMMARIZECOLUMNS( 'Calendar'[Date].[Month], Headcount[SAP ID], Headcount[Employee],Headcount[Line Manager Number],Headcount[Line Manager], FILTER('Calendar','Calendar'[Date]>EOMONTH(TODAY(),-2)&&'Calendar'[Date]<=EOMONTH(TODAY(),-1)))If not your case, please share some sample data and your expected output.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Regards,
Lin
rosscortbHi v-lili6-msft
Thanks for getting back to me.
That brought in loads of rows and for every day in November so when you filters on Date you get the 30 days in Nov and loads rows against each day.
- v-lili6-msft
hi rosscortb
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Regards,
Lin
- rosscortb
Hi
Worked it out by bringing in Date from headcount table rather than calendar table and using LASTDATE