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.
Hey everyone,
I have a requirement where user will select a date (dont have any relation with table) and data will be filtered accordingly based on following condition selected date<=effectivefrom and selected date>effectiveto.
So when i remove them result changes as shown in view (2).
So is there any way to achieve it?
Effort that i did:
I did applied it using direct query but its too slow and i want it done in import mode.Also dont want other approach which is hiding the column by turning of wrap text as reports will be sent as in excel.
Solved! Go to Solution.
Try
Sum of quantity =
VAR ChosenDate =
SELECTEDVALUE ( 'Date'[Date] )
VAR Result =
SUMX (
FILTER (
'Table',
ChosenDate <= 'Table'[Effective from]
&& ChosenDate > 'Table'[Effective to]
),
'Table'[Quantity]
)
RETURN
Result
Try
Sum of quantity =
VAR ChosenDate =
SELECTEDVALUE ( 'Date'[Date] )
VAR Result =
SUMX (
FILTER (
'Table',
ChosenDate <= 'Table'[Effective from]
&& ChosenDate > 'Table'[Effective to]
),
'Table'[Quantity]
)
RETURN
Result
Hi @mohtism ,
Did you try creating a relationship between your main table and this Date table?
Can you share more on if you have a data model?
hey @Pragati11 date will be provided from a manual table and it has no relation with main table.Beside this i still did this and its not working
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |