Hey Guys,
I am struggling to find a way to exclude items which do not have data in all the cells represented by the data range through Power Query in my pivot table.
I am therefore looking for a measure which I can include in my current measure to make sure that the following table will only include the columns with the headers: 1, 3, and 5 and thereby remove 2 and 4. The measure should be dynamic and adapt to the change of the time line slicer meaning that if the number of rows (data points) for e.g. column 2 is below the number of rows with dates, the measure should exclude this column completely.
Screenshot of the table:
Furthermore, I have attached a sample workbook (Link to the download of the workbook via google drive: PowerQuery_Sample_workbook_1.xlsx)
Here, the current measure I use to this calculation can be found.
I look forward to hearing your solutions.
Best regards,
Anton
I am struggling to find a way to exclude items which do not have data in all the cells represented by the data range through Power Query in my pivot table.
I am therefore looking for a measure which I can include in my current measure to make sure that the following table will only include the columns with the headers: 1, 3, and 5 and thereby remove 2 and 4. The measure should be dynamic and adapt to the change of the time line slicer meaning that if the number of rows (data points) for e.g. column 2 is below the number of rows with dates, the measure should exclude this column completely.
Screenshot of the table:
Furthermore, I have attached a sample workbook (Link to the download of the workbook via google drive: PowerQuery_Sample_workbook_1.xlsx)
Here, the current measure I use to this calculation can be found.
I look forward to hearing your solutions.
Best regards,
Anton
