User Profile

JARONN

Frequent Visitor

Joined 7 years ago

5 Posts1 LikeLikes received

View All Badges

User Widgets

Contributions

How to extract document name without defined dosument typy in Power Query
Hi I am trying to extract document names without defined document type string in document name. I have tried with lists etc without solution. Any ideas how this is possible to do in Power Query, please see simple example below, where original name is document name with document type in it, document type in separate column and modified name what I like to have. In other words, if document name includes document type in it, I would like add new column as "name without document type- string". Original_Name Document_Type Modified_Name Car number 1 diagram diagram Car number 1 Bike number 2 manual manual Bike number 2 Ship technical spreadsheet spreadsheet Ship technical
Solved
3 years ago Place Power Query
Need Help
417Views
0likes
1Comment
Re: Problems with dashboard tiles
Hi Dataset access should be ok, problems is now moving itself trough dashboards. If at this moment dashboard 1 is ok, 3 is partly working (3 missing tiles) and 5 is also ok, after application update dashboard 1 is missing 3 tiles, 3 is ok and 5 is now also missing some tiles.. There is like a random function making desicions which one of my dashboards is working.. This is really annoying. Update: Problemn might have something to do with copied reports. I replaced one copied report / dataset with new version and problem seems to be gone. Let see, hopefully tiles are now working correctly. -J
6 years ago Place Service
951Views
0likes
1Comment
Problems with dashboard tiles
Hi I created new application and copied some reports from another applications. I also made some dashboards, including visuals from copied reports. For some reason every dashboard is working fine for me, but other users are having problems with dashboard tiles - data is missing and there is only Power BI icon in it. I am owner in application and all other users have access to application. Sometimes this problem is solved by refreshing tiles, sometimes by refreshing the application but usually one or more of all 7 dashboards is having this issue. See picture below, Any ideas what is wrong? Update: there is also "Access needed" tiles, somehow related to access rights for reports - users have access to application.
Solved
6 years ago Place Service
Need Help
1KViews
1like
3Comments
Re: Problem with hour calculation
Thanks! With minor changes i got it.
6 years ago Place Desktop
744Views
0likes
0Comments
Problem with hour calculation
Person id Index 1 Code Work Order Index 2 date/time in/out calculation 1 50 in 102 xxxxx in 1 21 WO100 103 xxxxx in 1 22 WO106 104 xxxxx in 1 23 WO197 105 xxxxx in 1 51 out 106 xxxxx in Person id Index 1 Code Work Order Index 2 date/time in/out calculation 1 50 in 102 xxxxx out 1 21 WO100 103 xxxxx out 1 22 WO106 104 xxxxx out 1 23 WO197 105 xxxxx out 1 51 <>out 106 xxxxx out Index 1: Combined column from two tables, Codes and Work Orders. Index2 includes all data rows, ordered by combination of person id and date/time. Codes table contains all actions when personnel is stamping in/out, Work orders contains used work order numbers during the day (between in and out stampings). First example is where person has done right, in stamp – 3 x WO’s – out stamp. In this case all lines must be tagged as “in calculation” somehow. Second example is where person missed out stamp, in that case (in – wo’s – out – chain is broken) all lines must be tagged as “out of calculation” somehow. In other words, correct chain is Code in – x Work Orders – Code out, where x >= 0 So, daily “in calculation” data is included in metric and used to calculate working hours and how many hours of these working hours are assigned to WO’s. “out of calculation” data is excluded from metric. Hour calculation is done by date/time data. In and out stamps are easy to find and tag “in calculation” but all Work Order lines between correct in/out stamps are not solved. if code is “in” (index1 = 50, index2=102) and next code is “out” (index1=51, index2=106) then all lines between index2=102 and index2=106 must be tagged as “in calculation”. Else all lines must be tagged as “out of calculation”. Any Ideas?
Solved
6 years ago Place Desktop
Need Help
805Views
0likes
2Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.