Datetable as Filter

[_chris_]

Hi,

I have a fact table with date and revenue. Now I want to see ony the revenue of the actual month. I created a measure, something like

SUMX(revenue, FILTER(facttable, facttable[date}>blabla)

Now someone told me it would be better to have a date table and use this for filtering.

Now my question: Do I need to create a calculated "filtered" data table and create a relationship or is there another way with a measure?

Thx Chris 

[daxer-almighty]

Sorry to say that but your measure does not make any sense. The syntax of SUMX is completely different. Secondly, if you want to know how to CORRECTLY build models is Power BI, then you must read this: Understand star schema and the importance for Power BI - Power BI | Microsoft Docs