User Profile
TiwariNeha
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Need excel like format report to show the difference in cost for each SKU for the dates selected
Hi All, I have a requirement where we need a excel like format report where we need to show the difference of cost from one date to another. This date should be handled in the slicer where one date will be base and the other date will be acting as a anchor. Based on the selection of the dates in the slicer , we should see the reslult in the given gdrive link.User only wants to compare the two consecutive months. link : https://docs.google.com/spreadsheets/d/1HicELlkaa04ggqqeuyxpReiQpIq0MrXL/edit?usp=sharing&ouid=113338304003727638873&rtpof=true&sd=trueError while refreshing the data
Hi All, I am trying to use incremental refresh for the huge dataset consisting of around 80 Million Records. I have pro license. I am able to publish the report (Configured Incremental Refresh ) but for the first time when i am trying to refresh the complete report, it shows below error : I am using AWS Redshift with odbc connection as my backend dataset. Can anyone suggest any solution for the issue. Its urgent. Thanks & Regrads: NehaRe: How to avoid sum of duplicate values in a measure?
Hi Nathaniel_C Nathaniel, Thanks for your reply. The output that is coming from the suggested calculation is different from the expected solution. Let me explain , if we dont take the sanpdate 06/22/2020, then for period date 06/01/2020, Sum should be 1300 for product id 9 and 10 as there are no duplicates for that particular dates. Thanks & Regards: NehaHow to avoid sum of duplicate values in a measure?
Hi Power BI Community, I need some urgent help. Issue : How to avoid sum duplicate values in a measure .. Example: - We have 2 dates snap_date and period_date. In the Slicer, if I choose 'ALL' snap_dates and period_date as '6/01/2020', we will find the product_id = 10 is duplicated. So in case of duplication 'aggregation' should not happen, only Sales amount belonging to Latest snap date should show. In our Scenario Product_ID 10 is duplicate so it should only show Sales amount for its latest snap_date 6/22/2020 i.e sales amount = 3000 and should ignore 1000 Amount for date 5/22/2020. Also, Producd ID 9 , should show sales amount = 300 AND When user selects Both Product_ids(10 and 9) in the filter = sum should be 3300 but my sum is coming as 4300. Please find the Screen shots and Excel and PBIX file links. Current Output: - Required output:- Sharing : link for PBIX and EXCEL files https://drive.google.com/file/d/14SBMji1NqkCwShszz8Ap6Fi5g3ACpbAi/view?usp=sharing - PBIX https://drive.google.com/file/d/1-ZjTkywhMso1UpEnlkzkWbrvaX2eWpj_/view?usp=sharing - EXCEL Please feel free to contact 8130661129 for further clarifications
