User Profile
radiator
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Datediff - many wrong results
Hi all, I discovered there were issues with my datediff. It works and then it doesn't. When looking at a time period it looks like it starts not working when we are entering a new month. It works when the line is flat. Any idea what the issue here is? Best regards, radiatorPath error - value in source must also exist in dest
Hi all, I want to make a path column to filter on. The issue is that everytime new data is generated, all the new dest and source are paired, but the IDs generated in the dest will never be the same as the source. So I get the error in the headline. Is there a way to make this work or another technique of doing it? My idea was to generate a path for the current units, how they are populated today, then using the path to filter the history with CONTAIN to filter all the connected history of a current unit. Best regards, radiatorAverage length of production cycle - running total for finished cycles
Hi everyone, hope you can help me with my conundrum. I'm trying to find the average length of a production cycle, so i am finding the running total and the max of it for all production cycle names. But for the most recent data there are still active production cycles that are not finished yet, so the max running total will not be the final one and its of course affecting the average so we get a downward slope for the most recent data. I only want to include finished production cycles, and then that production cycle name just dissapears from the dataset. So I'm thinking something along the lines of checking every name if there is a count or not, and if it is then filter it out. But im not sure how it will work, becuase i need to run that logic on the different production cycle names, but in the end the number I will use is just the average. Hope this makes sense and thanks for any help! Best regards, OleRe: Merge hierarchical dim tables to improve model?
Hi Richard, Have you figured out a way of doing it? I have this pretty big model that I built since I was a beginner and didn't really understand, but I made it work somehow. A lot has been added to it since so I am looking to improve it. Like you I find nothing other than very basic data models used as examples for best practices, which is seldom the case in real life. For example I need to filter on system, but sometimes on the sub-system. Then there are units below there, and even sub-units. They all have different fact tables that are on the different granularities, and I kind of need a main system DIM to tie all the other DIMS together. E.g. DimSystem ->DimUnit->FactUnitValues, DimSystem -> FactSystemValues, And then a DimDate connected to all fact tables. Then I for example need some dimensions added to one fact table to describe a process. So then it becomes DIMSystem -> DimExtradimentions ->Factneedextradimentions. So i need to but in a DIM between the main DIM and the fact. Any thoughts? Best regards, OleFilter connected links/nodes back in time
Hi all, I want to be able to look at the history of a specific product that is in a specific place at the present/latest time. The products move throughout the factory and one has a population ID created for each location, and there is a table where the source and destionation IDs are stored. I would like to somehow filter on the connection of a certain product in a certain place, but not sure how to go forward with it. Basically I want to see the production history of THAT product that is THERE right now based on the links. I have been able to kind of do it in a Sankey, but it will only highlight one connection at a time. I wonder if the PATH function might be working for this, but not sure how to move forward with it. Any ideas are appreciated! Best regards, Hr. TetraRe: New DAX measures not showing up in connected reports
Finally, if the report is connection mode is "Live Connect", measures added directly in Power BI may not appear in the connected report. WHAT? MAY NOT???? Are you kidding me, what is the point of live connect then? And may not, so might happen, might not, that sounds very concerning in itself. And I presume you don't know why or why not it's working either? This is VERY CONCERNING and adds to the list of strange issues in the Microsoft suite lately. Get your act together! Best regards, RadiatorNew DAX measures not showing up in connected reports
Hi all, A coworker has built a report upon an existing Power BI dataset. He requested some new measures, but after I included and uploaded it to the dataset it is not showing up in that report. It is showing up in the original report with the dataset. Any idea what the issue here is? I expected it to appear once the dataset were uploaded to the service. Best regards, RadiatorRe: Populate column by condition (repeating) and text (change of state) from separate columns
Hi Neko Tang, Thank you for the reply, I appreciate it! It did replicate the single value, but it didn't repeat it like I wanted for all the in this case 'yes' columns: As you can see I did find another way of doing it that is giving the desired results: Utsett rep = IF(TestAddCol[MedFisk]="yes", CALCULATE(max(TestAddCol[Utsett]), ALLEXCEPT(TestAddCol, TestAddCol[Lokalitet]), TestAddCol[Dato]<=EARLIER(TestAddCol[Dato]))) Best regards, Radiator
