Forum Discussion

codyraptor's avatar
codyraptor
Resolver I
6 years ago
Solved

Roll Forward Calculation

I have the following data: Vendor ID, Load Date, Expiration Date.  I need a distinct count of vendor ID's.  New = 'min load date' where expiration date null or > than selected month.  Exp is 'max ex...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    codyraptor ,

     

    I'm afraid dynamic calculate table is not supported in power bi, so you couldn't generate such a table based on the slicer selection.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

codyraptor's avatar
codyraptor
Resolver I
6 years ago

This is great information.  However...I'm running into 1 snag.  My rows are not unique 1 load date..and or 1 expiration date.

Another words...
Vendor '123' could have a load date of Jan & Feb & etc..   The 'min date grouped by Ven 123' would represent their 'start date'

Vendor '123' could have a 'blank' and an expiration date.  I only want to count the expiration date if a null doesn't not exist on any row for that vendor id.  If blank exists..then it's not truly expired.   In the case 'all rows' are expired for the VEN 123..then I want the 'max expiration date'...

 

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

codyraptor ,

 

I'm afraid dynamic calculate table is not supported in power bi, so you couldn't generate such a table based on the slicer selection.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.