Forum Discussion
_chris_
5 years agoHelper III
Datetable as Filter
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
1 Reply
- daxer-almightySolution Sage
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