Forum Discussion
Why I am getting two values for MTD
I have created the measure to calculate MTD sales.
Sales MTD = TOTALMTD([Total Sales],DimDate[Date])
With above measure I am getting the following value.
To check the accuracy I manually filtered the Total Sales value with FactSales Table's date column as follows and I am getting a different value.
Again I filtered manually with Date table's date column and I am getting the measure value.
Please find the attached file herewith.
Anonymous , Date has a time stamp. I created a new date column. Joined Date of date with it. It is working fine now.
Date1 = date(year([Date]),month([Date]),day([Date]))
Please find the link https://www.dropbox.com/s/2k8fbgz0v9ecv3z/sample%289%29.pbix?dl=0
4 Replies
- amitchandak
Super User
Anonymous , Date has a time stamp. I created a new date column. Joined Date of date with it. It is working fine now.
Date1 = date(year([Date]),month([Date]),day([Date]))
Please find the link https://www.dropbox.com/s/2k8fbgz0v9ecv3z/sample%289%29.pbix?dl=0
- amitchandak
Anonymous , I opened the file, I am getting the Same value for both. Please let us know the parameters changed
Try to filter total sales in visual manually with FactSales[Date] instead of DimDate[Date]
Thank you for your help.