Forum Discussion

charlie_torres's avatar
charlie_torres
Frequent Visitor
3 years ago
Solved

Create a Matrix with Filtered Column Items based on a dynamic date range.

Dear @community, On the need for help again :[ after reading about many similar situations in the forum, but not quite the intended solution. The current problem is creating a matrix that follows a ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi charlie_torres,

    I'd like to suggest you use measure formula to instead the value field to use on matrix.

    You can use this formula to lookup raw table records and add a variable to extract the current row context date to use in compare with system date steps.

    After these steps, you can use an if statement to check current row context data to prevent the calculation in the not match ranges and move the corresponding expression into the if statements true branch.
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi charlie_torres,

I'd like to suggest you use unpivot columns feautre on the milestones fields to convert them to attribute and value.

Then you can use the unpivoted attribute on the matrix row, property field on column, the raw table date field on value fields with aggregate(first or last).

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng