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 ...
could you please provide the sample data and expected output?
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
I can't create tables because i have created a report starting form existing dataset
