Forum Discussion

Digger99's avatar
Digger99
Regular Visitor
3 years ago
Solved

Re-ordering Stock Date Format

Hi,   I am trying to work out when the best time is to re-order my stock, in a date format.   Below is a screenshot from the data I'm working with. There is a Product (ID & Name), Stock on Shelf ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Digger99 ,

    I have creatd a simple sample, please refer to my pbix file to see if it helps you.

    Create a column.

    Column =
VAR _1 = 'Table'[stock on shelf] - 'Table'[lead time]
RETURN
    EDATE ( TODAY (), _1 )

    Or a measure.

    Measure = 
VAR _1 =MAX( 'Table'[stock on shelf] )-MAX( 'Table'[lead time])
RETURN
    EDATE ( TODAY (), _1 )

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Digger99 ,

I have creatd a simple sample, please refer to my pbix file to see if it helps you.

Create a column.

Column =
VAR _1 = 'Table'[stock on shelf] - 'Table'[lead time]
RETURN
    EDATE ( TODAY (), _1 )

Or a measure.

Measure = 
VAR _1 =MAX( 'Table'[stock on shelf] )-MAX( 'Table'[lead time])
RETURN
    EDATE ( TODAY (), _1 )

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

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