Forum Discussion

briantc's avatar
briantc
New Member
2 years ago
Solved

Calculate cycle time with transaction data

Hi,  I'm very new to PowerBI and I'm having a problem calculating cycle time using transaction.  This is super simple in Excel, the data includes mainly parts numbers (Container Names) going through ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    hi, briantc 

    I'm happy to answer your questions. Sorry to hear that you are not sorting when importing data into power BI and it does not work when using calculated columns.  First of all, if the connection method we choose is the Import connection, we can sort the data in Power Query.

    My sample data is as follows:

    In Power BI table view:

    Using Power Query to sort data:

    The result after sorting:

    If the above sorting method helps you, that's great. If you have any questions, please let me know and I will do my best to solve your problem.

     

     

     

    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

    Jianpeng Li

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

briantc Looks similar to MTBF essentially. If you can post sample data and expected results could confirm. See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
  __Current - __Previous

 

Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.