Forum Discussion
Helper ISum data between unrelated tables
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
Most Valuable ProfessionalHi stephaniebl ,
change your monthTable to a complete date table and write the monthly values on the 1st of every month.
https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
You can then use a quick measure to create the YTD calculation.
https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
Helper Imwegener Ok i created a date table , how do i add the YYYYMM Data to the table without it being Many to many relationship to my other tables? I am not sure how to add the YYYYMM to only the first of every month.