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.
When looking at the summary matrix, the values are different than when I show the department matrix showing details.
Visual 1 shows correct and totals are correct at -598, but the details of the depts is not correct. The slicer is March to get this view which woudl be of February.
Fact Table 1 Showing P&L
Fact Table 2 Showing ATLAS
They are joined to a DEPT table, a DATE table and a UNIT table dimensionally. All are the same types/formats.
When I try to do PREVIOUSMONTH, it works for some, but not 0431, which is why the issue is coming up re the total vs the dept details. The below matrix has no filter on it except the unit. How does it have 852, 614, 545 but can't give it for prior P&L?
I've tried both DATEADD and PREVIOUSMONTH and am still getting blanks for 0431 despite the fact that i can see the values in the "P&L column"
@kmes912 , Is '01 Lookup Date' is a date table and also marked as date table in power bi (Right click)
Check 5 reason why TI fails - https://www.youtube.com/watch?v=OBf0rjpp5Hw
@amitchandak Yes it is marked as a date table. So bizarre that it shows for the other departments but not this one. I verified that 0431 exists on both the fact and dimensions tables. I dont get how it can pull current month fine but when you refer to prior works for certain depts but not for all.
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 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |