Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

POWER BI LIVE DATA

Hi all, 

 

Please if you have a solution for this one! I have a real time database which I am using for creating some Dashboards on Power BI ( not tables from an excel file). These datas are refreshed daily ( maybe twice per day). My question is : There is any Dax formula I can use to calculate cycle time without having a table? I am using already a formula like : DATEDIFF(MAXX(RELATEDTABLE(PROCESS),PROCESS(INITIATION DATE),MAXX(RELATEDTABLE(PROCESSHISTORY),PROCESSHISTORY(COMPLETEDDATE),DAY) but it's not so accurate. I want to calculate the cycle time from starting date until the completed date and to have only those dates who have 30 days until the request is processed. Hope this is clear enough and thanks !

Dashboards
Data Modeling

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Anonymous 

     

    Can you provide partial example data or a simple PBIX file? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

     

    Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, thanks for your answer. I can't share any data, but maybe if i explain better, you can help me. I have INITIATION DATE-THE TIME WHEN THE WORKFLOW START and Completed date - the time when the workflow ends. From this dates my only interest is to see for workflow "Processing Closing request" how many days are from Initiation Date until the completion Date. I have used already a formula to calculate it, but it's not 100% accurate. Datediff(maxx(relatedtable(process),process(initiation date),maxx(relatedtable(processhistory),processhistory(completeddate)),DAY) and it returns me how many days are between initiation date and completed date., but i want to know only those workflows that have greater than or equal to 30.