Forum Discussion
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 refres...
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.