Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |