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'm still finding my feet with Power Query and am in need of some help please.
So I need a Total invoice amount (which I already have a measure for) filtered by all open contracts (contract status has its own column) OR any contract status, open or otherwise, that have been dated in the last 7 days (I have a date table).
The below is what I have, I hope I'm close but it's just throwing up errors.
Relationships if needed
Thanks in advance for your response, im truly stuck here.
Theo
@T_Francis , In the case or Try to add a filter on the table like
qcontracttohire[date] <=max(date[date]) && qcontracttohire[date] >=max(date[date]) -7
Thank you for getting back to me.
So i'm trying to create a measure, is that wrong are you saying I should try to add a new column?
My data is across multiple tables.
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 |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |