DAX query with date parameter
Using Report Builder, I created a dataset that contains a date parameter. I need to add an order by to the DAX Query but am unsure of the correct syntax. Example is below. I need to order by 'Task'[ActivityDate] DESC DEFINE VAR vFromTaskActivityDateHierarchy1 = IF(PATHLENGTH(@FromTaskActivityDateHierarchy) = 1, IF(@FromTaskActivityDateHierarchy <> "", @FromTaskActivityDateHierarchy, BLANK()), IF(PATHITEM(@FromTaskActivityDateHierarchy, 2) <> "", PATHITEM(@FromTaskActivityDateHierarchy, 2), BLANK())) VAR vFromTaskActivityDateHierarchy1ALL = PATHLENGTH(@FromTaskActivityDateHierarchy) > 1 && PATHITEM(@FromTaskActivityDateHierarchy, 1, 1) < 1 VAR vToTaskActivityDateHierarchy1 = IF(PATHLENGTH(@ToTaskActivityDateHierarchy) = 1, IF(@ToTaskActivityDateHierarchy <> "", @ToTaskActivityDateHierarchy, BLANK()), IF(PATHITEM(@ToTaskActivityDateHierarchy, 2) <> "", PATHITEM(@ToTaskActivityDateHierarchy, 2), BLANK())) VAR vToTaskActivityDateHierarchy1ALL = PATHLENGTH(@ToTaskActivityDateHierarchy) > 1 && PATHITEM(@ToTaskActivityDateHierarchy, 1, 1) < 1 EVALUATE SUMMARIZECOLUMNS('Task'[WhatId], 'Task'[Status], 'Task'[Description], 'Task'[ActivityDate], FILTER(VALUES('Task'[ActivityDate]), (vFromTaskActivityDateHierarchy1ALL || 'Task'[ActivityDate] >= DATEVALUE(vFromTaskActivityDateHierarchy1) + TIMEVALUE(vFromTaskActivityDateHierarchy1)) && (vToTaskActivityDateHierarchy1ALL || 'Task'[ActivityDate] <= DATEVALUE(vToTaskActivityDateHierarchy1) + TIMEVALUE(vToTaskActivityDateHierarchy1)))) Any assistance is appreciated.
How to exclude one field from summarize columns but still include it in the query
Hi, I had to introduce the field [PlannedMigrationDay] in my query for the paginated report for the sole purpose of filtering the paginated report. This is the query: /* START QUERY BUILDER */ EVALUATE SUMMARIZECOLUMNS( UserResponse[Batch], UserResponse[Response], UserResponse[PlannedMigrationDay], KEEPFILTERS( TREATAS( {"2"}, UserResponse[TenantID] )), KEEPFILTERS( TREATAS( {"4"}, UserResponse[QuestionID] )), "Responses", [Responses], "Responses %", [Responses %], "T-14", [T-14] ) /* END QUERY BUILDER */ Now I have one problem: when I have two different migration dates, my results are summarized by the date of migration whereas before they were aggregated by distinct values. I don't want my results to be aggregated by [PlannedMigrationDay]. How can I modify the query to avoid that, but still have that field in the dataset of my paginated report? Thanks in advance for the help! ~Alienvolm
Dax Query
Hi, I am faceing one issue with dax query which is written in DAX Query application. dax query is - EVALUATE ADDCOLUMNS ( SUMMARIZECOLUMNS ( 'Dim MWBEProgram'[MWBEProgramName], FILTER ( 'Fact Contract', 'Fact Contract'[MWBEProgramID] <> BLANK () ), FILTER ( 'Fact Contract', 'Fact Contract'[ContractNumber] = "1234" ) ) , "STATUS", IF ( 'Dim MWBEProgram'[MWBEProgramName] = "Non M/WBE", "NON M/WBE", "M/WBE" ) ) So, getting output like this: Is it possible to get only 'STATUS' Column?
