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.
Solved! Go to Solution.
ThanK you @deevaker the solutioin worked.
LastWeek = CALCULATE(SUM('Occupational Safety'[Value]),filter(ALLEXCEPT('Occupational Safety','Occupational Safety'[PPE],'Occupational Safety'[YEAR]),'Occupational Safety'[Week]=WEEKNUM(TODAY(),1)-1))
First measure looks correct. Hope the relationship between your tables are fine.
In second table, look like you need to use >= instead of = while doing filter.
LastWeek = CALCULATE(SUM('Occupational Safety'[Value]),filter(ALL('Occupational Safety'[Week]),'Occupational Safety'[Week]>=WEEKNUM(TODAY(),1)-1))
@deevaker Could you look at my Dax Measure? do all columns have to reference the same table?
Thanks,
But I tried it but it didn't work.
Shall we check. you can ping me on skype - deevaker1
ThanK you @deevaker the solutioin worked.
LastWeek = CALCULATE(SUM('Occupational Safety'[Value]),filter(ALLEXCEPT('Occupational Safety','Occupational Safety'[PPE],'Occupational Safety'[YEAR]),'Occupational Safety'[Week]=WEEKNUM(TODAY(),1)-1))
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 |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |