Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |