Forum Discussion

djkoenig's avatar
djkoenig
Icon for Helper II rankHelper II
2 years ago

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...
Need Help
djkoenig's avatar
djkoenig
Icon for Helper II rankHelper II
2 years ago

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. 

 

  • JohnnySaade's avatar
    JohnnySaade
    Icon for Helper I rankHelper I
    2 years ago

    Can you share an image of the relationship and any other relevant information maybe a small saple of the table YYY1?