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.
I only get total of the SAMEPERIOD LAST YEAR at the bottom. I can not get numbers by months. Any ideas?
Solved! Go to Solution.
Hi @Anonymous
You could add a Date table into your model, and create a relationship between Date[Date] and Klant[Date] columns (one-to-many & single direction). Then use Date table's columns in Time Intelligence functions and Table visuals. When you use Date columns from Other tables, you may get blank values because of the filter context in a visual.
For example,
See difference of the results:
Hi @Anonymous
You could add a Date table into your model, and create a relationship between Date[Date] and Klant[Date] columns (one-to-many & single direction). Then use Date table's columns in Time Intelligence functions and Table visuals. When you use Date columns from Other tables, you may get blank values because of the filter context in a visual.
For example,
See difference of the results:
Klant[Sample_Date] doesn't look like a date table to me. You need to use the Date[Date] field (or whatever you name it) from the true date table, not a date field from one of the other tables.
I'd need to see your model, or better yet your PBIX file, but I suspect this is a modeling issue. The Time Intelligence functions work over date tables, not any date field.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |