Forum Discussion
Solved
TOTALYTD
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?
could you please provide the sample data and expected output?
5 Replies
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])
thanx but please help me with teh following code
The mistake is at red text
IF(ISFILTERED('Opportunities'[Actual Close Date]),ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),TOTALQTD(SUM('Opportunities'[Actual Won Sales Price_Base]),'Opportunities'[Actual Close Date]))maybe you can try to create a datetime table and change the red part to datetime date key
