Forum Discussion
Date as KPI
Hello,
I am trying to put the date as a KPI. Basically if a filter is on a date, then the date should be shown as a big text in the dashboard header. Unfortunately, it shows a #0.00 whenever i filter on the date.
This is the formula:
Date filter = IF (
HASONEVALUE ( DimDate[Date] );
VALUES(DimDate[Date]) ;
"YTD Cumulated"
)
Cheers
Hi alxmti,
The question you are getting is that you have two format in your final result so the KPI only returns one type in this case Number you need to change your formula to something like this:
Date filter = IF ( HASONEVALUE ( DimDate[DAte] ); FORMAT ( VALUES ( DimDate[DAte] ); "dd-mm-yyyy" ); "YTD Cumulated" )Format the date part as best fits your needs
Regards,
MFelix
2 Replies
Hi alxmti,
The question you are getting is that you have two format in your final result so the KPI only returns one type in this case Number you need to change your formula to something like this:
Date filter = IF ( HASONEVALUE ( DimDate[DAte] ); FORMAT ( VALUES ( DimDate[DAte] ); "dd-mm-yyyy" ); "YTD Cumulated" )Format the date part as best fits your needs
Regards,
MFelix
thanks! something as easy as FORMAT :)
