Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
All rows where List_Date is before LAST DAY OF MONTH
AND
(Binding_Ag is between FIRST DAY OF MONTH and LAST DAY OF MONTH) OR (Expiration date is between FIRST DAY OF MONTH and LAST DAY OF MONTH) OR Binding_Ag is blank
List_Date Is a one column.
Binding_Ag is also one column.
Expiration date is a column
Please let me know can we add query for this. Last Day of Month and First Day month is select by user and we need to show result.
Solved! Go to Solution.
@Anonymous
You just need to use FILTER() function to get the expected table context.
Create a calculated table like below:
Calculated Table = VAR FirstDayOfMonth = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) VAR LastDayOfMonth = EOMONTH ( TODAY (), 0 ) RETURN FILTER ( Table, Table[List_Date] < FirstDayOfMonth && ( Table[Binding_Ag] >= FirstDayOfMonth && Table[Binding_Ag] <= LastDayOfMonth ) || ( Table[Expiration date] >= FirstDayOfMonth && Table[Expiration date] <= LastDayOfMonth ) || Table[Expiration date] = BLANK () )
Regards,
@Anonymous
You just need to use FILTER() function to get the expected table context.
Create a calculated table like below:
Calculated Table = VAR FirstDayOfMonth = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) VAR LastDayOfMonth = EOMONTH ( TODAY (), 0 ) RETURN FILTER ( Table, Table[List_Date] < FirstDayOfMonth && ( Table[Binding_Ag] >= FirstDayOfMonth && Table[Binding_Ag] <= LastDayOfMonth ) || ( Table[Expiration date] >= FirstDayOfMonth && Table[Expiration date] <= LastDayOfMonth ) || Table[Expiration date] = BLANK () )
Regards,
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |