To create a summarized column in dax

[sajal161292]

Hi,

I have this requirement to represent the data as this:

I need to aadd an additional column “Past Due” prior to the dates to sum-up the information from the past:

Could you please tell me a way of achieving it using dax

[Anonymous]

HI @sajal161292,

I'd like to suggest you use unpivot your table to convert date columns, then you can simply create a calculate column to look up previous data based on data column.

Unpivot columns (Power Query)

If you still need some help for coding dax with 'unpivoted records', you can share some sample data and expected result here with table format.

Regards,

XIaoxin Sheng

[sajal161292]

Hi,

I need to add an additional column "Past due" which contains all the information from the past and summarizes it in the report.

This column should be a static field so that whenever user selects any date range then he should be able to see all the previous data in the column "Past due".

example: if user selects 11-June-2018 then the Past due column should contain all the data(POs that are still open but not yet received yet) till 10-June-2018 

Please find my PBIX file below:

https://drive.google.com/open?id=1p2w1pXsyg7XQYgzIBZRx3HmBaD9UJyUI

Please help me in achieving this requirement.

[Anonymous]

Hi @sajal161292,

Current power bi not support to create dynamic column/table based on slicer/filter, please use measure to instead.

BTW, after research your report, I found you only need to add a slicer with before mode, and turn on column total. Matrix visual will auto summary previous result on total column.

Regards,

Xiaoxin Sheng

[sajal161292]

Hi,

Thank you for your reply!!

But actually the dataset is consisting of dates from 2013 and so selecting before inthe slicer will not render it in the report.