filter a summarised table by date

Question

Hi, I have a summarised table based on the transaction table.

Then I have a page with visuals using measures based on the summarised table.

Now I want to filter the visuals to one month only. Is it possible?

amitchandak · Answer

You can join your summarized table to your Calendar table and filter ?

gtamir · Answer

amitchandak&nbsp;How? there is no common field.

amitchandak · Answer

Does that table has Month, Then use that as a filter. I think I am confused now. Please explain the issue with an example.

greg_deckler · Answer

Depends but should be possible. However, a definitive answer would require additional information.&nbsp;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/38490

gtamir · Answer

All the visuals are based on measures

Forum Discussion

filter a summarised table by date

9 Replies

Related content

Filtered table

Grouping and summarising

Summarised table and slicer not working

Can't linked a summarised table

Summarise