Forum Discussion
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) ...
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