Forum Discussion
Contiguous Date Selections, Invalid Numeric Representations, and General Confusion
Hello Experts, I'm new to Power BI and running into an issue with dynamically calculating MTD, QTD, YTD. My values are correct in summation, however, when I add a slicer to the report, my measur...
Hello JohnnySaade,
Interestingly enough removal of the offset year then gives me the entirety of all Sales, even with the SAMEPERIODLASTYEAR clause.
The basic formula
Invalid Test = Calculate(Sum(YY1_BI_Customer_Sales[NetAmount]), SAMEPERIODLASTYEAR('Calendar'[Date])) seems to only be paying attention to the first arguement. I feel this would suggest an improper relationship between the calendar table and the sales table. But, I can place the info in a Maxtrix/Table and it displays properly with the correct allocation of Sales per product.
Can you share an image of the relationship and any other relevant information maybe a small saple of the table YYY1?