Forum Discussion
Previous Quarter No Result
All, I want to know my previous quarter dollar ammount shipped. I am having an issue due to when I calculate previous quarter, it does not show anything. This is what I came up with thus far: ...
All,
I am trying to get my previous quarter dollar ammount shipped. It is worth to mention that I am working on a data model I created in SQL Server Analysis Srevices. The model has a CALENDAR table, so I am using the date from this table. My dax formula thus far is:
PREVIOUS Q DOLLAR AMMOUNT:=CALCULATE([TOTAL DOLLAR AMMOUNT SHIPPED],PREVIOUSQUARTER(CALENDAR[DATE]))
But this formula is not returning anything. I triend to use a date column from my fact table but I will get an error stating that I can not use a column with duplicate values. Any sugestion?
Thanks,