Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |