User Profile
sneddon65
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Re: Measures in Power BI Calculation
I'm wondering if anyone can help me with a MEASURE calculation within a tabular report in Power BI desktop. Here is the challenge. I have a tabular visual in PBI desktop producing trip data including Vehicle Registration, Start date and time and End date and time from some different tables in my sql database. I also have a final end odometer reading but I do not have the start odometer reading in each row of data. I need a MEASURE formula to lookup the previous date and time based on the Vehicle Registration so that i have a Start and End Odometer reading and then from that I calcxulate the journey length. Is this possible? The Vehicle table stores the Registration and another table stores the dates / times and the end odometer reading. The two tables are connected by a Vehicle Id.3.1KViews0likes0CommentsRe: Publishing confidential Reports and Dashboards to external users who have a PBI pro licence
So I guess i am asking a couple of things. We have privacy concerns with this data so how secure is this process. We have a group of reports to sahre with users outside our organisation but with PBI Pro licence. What is the best way to share the worksapce with them?1.4KViews0likes1CommentRe: Calculate Hours between dates for only business hours
Is it posssible to do a calculation within the hour table instead of having another table - result table. I have other data in the hour table which I want to use but cannot connect the tables using a merge or append query as there is no suitable field. Kind regards13KViews0likes0Comments
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.