Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@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
@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
@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]
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |