Taking a visual studio statement and changing it to DAX
I have a visual studio report that requires two fairly critical query statements based on two parameter fields: 1. NEWSTARTDATE=IIf(Parameters!StartDate.Value>Fields!new_arrivaldate2Value.Value,Parameters!StartDate.Value,Fields!new_arrivaldate2Value.Value) 2. NEWENDDATE=IIf((IsNothing(Fields!new_departuredate2Value.Value) = true)Or(Fields!new_departuredate2Value.Value>Parameters!EndDate.Value),Parameters!EndDate.Value,Fields!new_departuredate2Value.Value) Essentially these make arrival date 1st of the month if good arrived earlier than this and make departure date end of month for any goods still in stock (allowing for a calculation on storage costs for the month to be performed). I really want to be able to replicate this in power BI, which I suspect is possible, but I am struggling with the use of parameters and rewriting the two statements in DAX (I have very limited knowledge of power BI). I would be hugely grateful if someone was able to point me in the right direction.
Power Bi Report Server does not load language file from Visual Studio initially
Hi PBI experts, besides PBI Desktop, we use Microsoft Visual Studio for designing and altering Tabular Models. There you can easily export a language file, then edit it with a text editor and then import the language file. In Power BI Desktop the language of the user's system is selected automatically. Last month, we have installed the PBI report server. We still have a issue with the language file loading in a internet browser. When opening the report via an internet browser, the language file from Visual Studio is not loaded initially. Only, after refreshing the browser (F5) the language file will be selected an the report is translated (similar like in PBI Desktop). Even after logging out and again logging in, the language file will be loaded. Do you have an idea why this happens and how I can fix it? Best regards Ömer S.Visual Studio SSDT System.Security.Permissions.SecurityPermission
Hi, I have VS 2019 and SSDT installed local on my computer. I have an expression in the textbox, using "Floor", "Abs". When I try to preview the report on my computer, it gives "#Error" In the Visual Studio, window: error list, it shows as [rsRuntimeErrorInExpression] The Value expression for the textrun 'Textbox133.Paragraphs[0].TextRuns[1]' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Note: When I publish this to PBIRS, report works fine. only shows error on my computer's visual studio / ssdt. Also, works on Report Builder when I open ... Any idea? Thanks
