https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weekly-aggregations-not-picking-up-appropriate-data-when/m-p/993381#M12382 <P>Please see this post regarding How to Get Your Question Answered Quickly: <A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A></P> Thu, 26 Mar 2020 13:15:13 GMT Greg_Deckler 2020-03-26T13:15:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weekly-aggregations-not-picking-up-appropriate-data-when/m-p/992496#M12368 <P>I have two tables that have similar information. One is an automatically generated statistical table and the other is manually refreshed from the general ledger. Periodically we need to “true up” data with the general ledger data.&nbsp; I have written an if statement that mostly gets the job done. The issue is that the weekly aggregations do not pick up the statistical data in the if statement.</P><P><img /><img /></P> Thu, 26 Mar 2020 16:42:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weekly-aggregations-not-picking-up-appropriate-data-when/m-p/992496#M12368 Anonymous 2020-03-26T16:42:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weekly-aggregations-not-picking-up-appropriate-data-when/m-p/993381#M12382 <P>Please see this post regarding How to Get Your Question Answered Quickly: <A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A></P> Thu, 26 Mar 2020 13:15:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weekly-aggregations-not-picking-up-appropriate-data-when/m-p/993381#M12382 Greg_Deckler 2020-03-26T13:15:13Z