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.
Order By in VS to represent in Power BI
I am using a SQL Server connection in VS and importing tables. In my table, I have a Date column and then another column that is extracting the Month_Name of the Date column. Example Date Month_Name 01/05/2021 January 03/07/2021 March 08/21/2021 August I used the following script in Advanced Editor in VS to do this: #"Extracted Month Name" = Table.TransformColumns(#"Filtered Rows", {{"Month_Name", each Date.MonthName(_), type text}}) Then when I go to by Power BI dashboard and display the Month_Name in a table, it is not ordering by date, it's ordering alphabetically. (August, January, March) How do I get this column to order by date? (Can't edit the column in PBI since I'm using a VS connector)
How to delete everything after a dash and put the remaining text on 4 characters in DAX?
I have in Visual Studio a table `Y2_Sales` which contains a column "`color`" with values like this : 85-GREY MARLE 90-BLACK 90-BLACK 1000-WHITE 49-NAVY 90-BLACK 3021-BONE I would like to make a calculated column in my template and delete everything after the dash and put the remaining numbers on 4 characters, which would give : 0085 0090 0090 1000 0049 0090 3021 I tried this formula but it returns me for example `90-` how to remove this last dash? =LEFT([color], IF (SEARCH("-",[color],1,0) > 0, SEARCH("-",[color],1,0), LEN([color]) ) ) Could someone help me?
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
