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,
i'm tring to work with TOTALYTD but it occurs an error on date parameter.
My date format is like the picture this
but it needs the following [date] format
I cant change anything because my table came from an existing dataset.
Can I convert the date format with DAX command in order it works correctly?
Solved! Go to Solution.
could you please provide the sample data and expected output?
Proud to be a Super User!
do you have a datetime table?
https://docs.microsoft.com/en-us/dax/totalytd-function-dax
maybe you can try
measure =
VAR _maxdate=max(Sales[date])
return sumx(FILTER(all(sales),Sales[date]=year(_maxdate)),Sales[Sales])
Proud to be a Super User!
thanx but please help me with teh following code
The mistake is at red text
maybe you can try to create a datetime table and change the red part to datetime date key
Proud to be a Super User!
I can't create tables because i have created a report starting form existing dataset
could you please provide the sample data and expected output?
Proud to be a Super User!
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |