Need help to Get latest records from table data by adding flag
Need to get latest record based on each file group on below conditions. PBIX URL : https://drive.google.com/file/d/1YNkpQQKhtOejgPtj48bmS6v6MyadYnfN/view?usp=sharing 1.Sourcesystem="DB" is latest. 2. if file is not available in Sourcesystem="DB" ,check Sourcesystem="App" and Sourcesystem="app" and stepdescription = "Import " is latest. 3. IF stepdescription = "Import " also file not available. stepdescription = "Transfer " is latest. Pls find below screen shot for source data and highlighted color indicates expected output. Tried below script but expected result not coming . need help. Test 1 = IF ( CALCULATE( COUNTROWS( VALUES('Data'[FileName]) ), FILTER( ALL('Data'), 'Data'[FileName] = EARLIER('Data'[FileName]) && 'Data'[SourceSystem] = "DB" ) ) > 0, IF ( 'Data'[SourceSystem] = "DB" , 1, 0 ), IF ( 'Data'[SourceSystem] = "App" && ( CALCULATE( MAX('Data'[StepDescription]), FILTER( ALL('Data'), 'Data'[FileName] = EARLIER('Data'[FileName]) && 'Data'[SourceSystem] = "App" && 'Data'[StepDescription] = "import" ) ) = 'Data'[StepDescription] || CALCULATE( MAX('Data'[StepDescription]), FILTER( ALL('Data'), 'Data'[FileName] = EARLIER('Data'[FileName]) && 'Data'[SourceSystem] = "App" && 'Data'[StepDescription] = "transfer" ) ) = 'Data'[StepDescription] ), 1, 0 ) ) above script giving output like below .
How to export the description info from the Model View in Power BI?
Hi Team, In the Model View, there is a "Description" info show on the Properties section. May I know how to export the "Description" info for all columns? or is there any effience way to show the rename column vs. origianl column? Thanks! Best regards, Mandy
Slicer of filter values are with data type (i.e) whole integer, But not getting search option?
Hi Team, Good Morning! Currently in my slicer of filter values are with data type i.e whole interger. and the values are shown with 12 digit number like below snapshot. Can you please suggest, If data type change it to text then we will get serach option, but it is not correct way. Please suggest how to fix this issue(suggest with snapshots please) or any DAX or any other way. Kindly help me to fix this issue. Thanks in Advance.
total sum value in table visual is wrong
im trying to calculate the total commission by all salespersons. i have 2 tables , one table shows the commission by catgory and the other table shows sales transactions by salespersons. i created a joining column in power query by concatenating 3 columns in the packages table to have 1 unique key in the tabel so that i can join with the other table. after i joined the two tables with 1 to many relationship and cross filteting then created a table visual that shows : agent name - categoty-sales-commission value the sales total is correct but the commission is not correct. the commission is taken from the categories commission table and the rest of columns are from the categories transactions table. the correct total commission should be much higher=973.605 any idea of what could lead to wrong total sum value while value per row is correctKindly help me for conditional checkbox with action required on dropdown filter of below snapshot.
Case 1 : Filter beside below highlighted snapshot of red color highlighted check box how we will place? Case 2: And If you check the checkbox and select the dropdown, then it should show all the list of names. Case 3: If you uncheck the checkbox and select the dropdown, then it should show all the list of names. Kindly can you please suggest and do needfull for above cases!
Kindly help me for conditional checkbox with action required on dropdown?
Case 1 - Filter beside snapshot of red color highlighted check box how we will place? case 2- And if you check the checkbox and select the drop down, then it should show all the list of names. Case 3- If you uncheck the checkbox and select the drop down,then it should show all the list of names. Kindly can you please suggest and do the needful for above cases.
Help with DAX
Hi All, Hope you are all safe and well. Just want some help with a DAX please as follows. I'm creating a dashboard with lead start date from Leads entity and want total distinct customers from Customers table to be displayed who have start date >= Opportunity close date. Also, want to get purchase amount total for the customers to be available as well. So, based on the lead start date filter, the respective opportunities who are having link to Account which is connected to customers through service table needs to be displayed. The relationship from power bi model is as follows. Hope to hear from you. Regards Sanj
