Date as KPI

[alxmti]

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

[MFelix · Accepted solution]

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

[alxmti]

thanks! something as easy as FORMAT 🙂