Forum Discussion
stephaniebl
Helper I
Helper ISum data between unrelated tables
Hello, I have two sales data tables, one includes captured sales revenue & the other contains adjustments that are made to the revenue due to returns/late additions/etc. In order to get true sa...
Hi stephaniebl ,
did you change the m:n relationship?
You may download my PBIX file from here.
Hope this helps.Hi stephaniebl ,
are you using the date table now?
Create a sales measure...
Sales = SUM('CIA/HCA Cognos Revenue'[Extended Sales PMAR Amount]) + SUM('Adjust & Quota'[Adjustment])... and a YTD quick measure
https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
mwegener
Most Valuable Professional
Most Valuable ProfessionalHi stephaniebl
try this
Date = DATE(LEFT('Adjust & Quota'[YYYYMM],4),RIGHT('Adjust & Quota'[YYYYMM],2),1)
stephanieblHelper I
Helper Imwegenerdo I add this to my date table as a new column?