Forum Discussion
AlessandroBet
Helper V
Helper VTOTALYTD
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?
AlessandroBetHelper V
Helper Vthanx 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]
)
)
ryan_mayu
Super User
Super Usermaybe you can try to create a datetime table and change the red part to datetime date key
- AlessandroBet
I can't create tables because i have created a report starting form existing dataset
- ryan_mayu
could you please provide the sample data and expected output?