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.
not able to visualize the YTD sales ... so what is wrong in the dax
Total Sales YTD = TOTALYTD(sales_attributes1[Total Sales],sales_attributes1[DATECREATED] )
the calculation error in sales[total sales ytd]: a date column containing a duplicate date was specified in the call to function 'datesytd' this is not supported
4 years late but ... So I have found out If you already have a Column that has the dates lets call it {Date item was sold} or in your case if it lists the dates in a format such as {Friday, January 28,2022} then it the [TotalYTD] funtion won't work as a approrate value for the <Date> portion of the measurment.....and gives you the error you have seen.
The Date format I have seen the [TotalYTD] measure function like is MM/DD/YYYY once I Transformed my data in the {Date item was sold} from the date format of {Friday, January 28,2022} to {1/28/2022} then it worked like a charm!
hi, both i tried doing the same by using calendar function the issue is i am getting a blank totalytd
Evening,
In tabular data models (power bi, tables & relationships) it's best to create a related date table to your fact table.
Your fact table typically contains all of your data, for example transaction log.
Your Date table is a representation of dates and the associated valeus as so you can filter against and use the columns in place of dates values from your fact table.
Here is a great template of a date table (https://www.sqlbi.com/articles/reference-date-table-in-dax-and-power-bi/); you can also google about for some simple Power Query to build you a super basic date table. Once you've added that in, join your fact and new date table with a relationship by the Date column in your fact table and the DateKey in the date table.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |