Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |