Countdown timer for offer period

[Anonymous]

Hi,

We have a dashboard displaying sales achieved / to be achieved  details during the offer period which is from 20th November 2022 to 31st December 2022.  We would like to add a countdown clock like dynamic card which shows the days left for offer sales period.  I know there is a custom visual available in store but I would like to get it done with a DAX.  Request your guidance

regards,

dsmitha

[VahidDM · Accepted solution]

HI   @Anonymous 

Do you just want to show the days left on that card (CountDown)?

You can use a measure like this:
Remained Days = DATEDIFF( DATE(2022,12,31), Today(), DAY)

More info about this formula:
https://learn.microsoft.com/en-us/dax/datediff-function-dax?WT.mc_id=DP-MVP-5004936

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

[VahidDM · Accepted solution]

HI   @Anonymous 

Do you just want to show the days left on that card (CountDown)?

You can use a measure like this:
Remained Days = DATEDIFF( DATE(2022,12,31), Today(), DAY)

More info about this formula:
https://learn.microsoft.com/en-us/dax/datediff-function-dax?WT.mc_id=DP-MVP-5004936

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

[Anonymous]

HI VahidDM,

Also, if you can help me

How can we show the count down hours / minutes / seconds 

regards,

dsmitha

[VahidDM · Accepted solution]

You can write some dax, change the intervals to hours, minutes, .... then you can format the output.

Check this blog post:
https://www.vahiddm.com/post/calculating-business-hours-in-power-bi-using-dax

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[Anonymous]

hi VahidDM,

Thank you so much for sharing the link, helped a lot

regards,

dsmitha

[Anonymous]

hI VahidDM,

Thank you very much, this is exactly what i was looking for

double kudoz

regards,

dsmitha