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.
Hi all,
I´m trying to create a new measure to have the volume sold as of YTD.
Both sales volume comes from the same table (Sheet1) but somehow the calculation is giving me an error.
Can somebody please help me with this?
Solved! Go to Solution.
Your Recons_Date column is not a Date/Time type, it is Text. You need to feed TOTALYTD a true Date/Time column type.
@Mega79,
I would recommend you directly select your Recons_Date column, and change its data type to Date as shown in the following similar screenshot.
Then create YTD using DAX below.
Ventas YTD = TOTALYTD(SUM(Sheet1[Qty_sold_in_UPC_UOM]), Sheet1[Recons_Date])
Regards,
Lydia
Your Recons_Date column is not a Date/Time type, it is Text. You need to feed TOTALYTD a true Date/Time column type.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |