Date value available, still returns as Blank
Hi All. I am facing a very strange situation where I have one table which has around 17k records & each record has date value and the data type is Date too. I want to write one measure based on the date but it is not giving the desired result as date field treated as blank. Below is the actual screenshot. I tried with MAX,MIN also, still same result. The below table visual values are coming from same table, so no issue of Relationship.
RSCustomDaxFilter - Paginated Report
Hi Team, I'm working on paginated report. I want to make Last Name and Worker Id parameters optional. User can seleter either Worker Id or Last Name. Can you please help me add a Or conditon in RSCustomDaxFilter? In case user selects Work Id, Last Name should be passed as null. EVALUATE SUMMARIZECOLUMNS('Sample Data'[First Name], 'Sample Data'[Last Name], 'Sample Data'[Worker ID], 'Sample Data'[License Number], 'Sample Data'[Jurisdiction], 'Sample Data'[JurisdictionDesc], 'Sample Data'[Company Name], 'Sample Data'[EmployeeOfficeLocation], 'Sample Data'[Processing Date], 'Sample Data'[Author/Content Credits], 'Sample Data'[Instructor Credits], 'Sample Data'[Learner Credits], 'Sample Data'[Carry Applied], 'Sample Data'[Rule Applied], 'Sample Data'[subjectType], 'Sample Data'[courseCode], 'Sample Data'[providerRegistryNumber(Sponsor ID)], 'Sample Data'[providerName], 'Sample Data'[courseLocationState], 'Sample Data'[Multi-Year RP End Date], 'Sample Data'[Multi-Year RP Start Date], 'Sample Data'[courseDateEnd], 'Sample Data'[courseDateStart], 'Sample Data'[courseDeliveryMethod], 'Sample Data'[courseName], 'Sample Data'[Limitation Reason], RSCustomDaxFilter(@SampleDataLastName,EqualToCondition,[Sample Data].[Last Name],String), RSCustomDaxFilter(@SampleDataJurisdictionDesc,EqualToCondition,[Sample Data].[JurisdictionDesc],String), RSCustomDaxFilter(@SampleDataWorkerID,EqualToCondition,[Sample Data].[Worker ID],String)) Thanks, FayyazPaginated Reports Query
Hello All, I have created the paginated report, and the visual is table which have columns from different tables and no aggragate column is used as columns only few stings based columns are there, when I run it, i gives 1st error as given below and second error is when i remove blank values from column it gives second error. I am using PBI dataset as data source. If i use the some aggregation column in the end it works. Please guide me with this. Thank you in Advance lbendlin amitchandak tamerj1 Greg_Deckler onurbmiguel_
Facing an Error while trying to connect Power BI with MySQL workbench
Hi Power BI community, I have MySQL Workbench in that i have two connections. one is the Localhost and one is the other server. when I try to connect the Local Host to the Power BI i am getting an Error. and When I try to connect the other server to the Power BI i am getting a different Error. please help me with this Error. Thanks & Regards, Ibrahim Shaik
Who logs in to PowerBI & to which reports - over a custom timeperiod?
Hello, I am wondering if I can track how frequent users login to/use PowerBI & which reports they have watched over a custom timeperiod (e.g. 1 year)? I understood currently that we can only view the reporting now over the past 3/4 weeks and that we need to do this analysis on report level (and cannot do it in bulk) Is this correcT? The goal is to understand which users really make use of PowerBI and of which reports and which users never login. Many thanks for your help & time upfront. KR, CharlotteReplace the value Based other column particular market
I have the table name called Global POL. this table have three column . i am trying to replace the packtype value for particular market UA04 .this market vakue trying to set null value value. when i use replace value its changed for the all market Market packtype UA04 SOFTPACK UA04 REMARK CA04 SOFTPACK CA04 REMARK MA04 SOFTPACK MA04 REMARK Expected Output: UA04 UA04 CA04 SOFTPACK CA04 REMARK MA04 SOFTPACK MA04 REMARK Looking for support . thanks in advance .
