cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GabrielaCosmina
New Member

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 !

3 REPLIES 3
GabrielaCosmina
New Member

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.

 

 

v-zhangti
Community Support
Community Support

Hi, @GabrielaCosmina 

 

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

amitchandak
Super User
Super User

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors