topic Re: How to Show Delta Between TODAY() and Modified Date formatted as Days in Dax in DAX Commands and Tips

How to Show Delta Between TODAY() and Modified Date formatted as Days in Dax

Gopal_PV — Fri, 01 Dec 2023 16:19:22 GMT

Hi Friends,

I have requirement to how Delta Between TODAY() and Modified Date formatted as Days in the Card in the report.

And i want a slicer to select below as

Input Number of Days Since Modified” as a drop-down selection that buckets day thresholds as follows:

< 30 Days
> 30 Days and < 60 Days
> 60 Days and < 90 Days
> 90 Days

Can you please help me how to create dax measures or columns.

Re: How to Show Delta Between TODAY() and Modified Date formatted as Days in Dax

lbendlin — Sun, 03 Dec 2023 20:54:14 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: How to Show Delta Between TODAY() and Modified Date formatted as Days in Dax

Gopal_PV — Wed, 06 Dec 2023 11:29:05 GMT

Hi lbendlin

Thank you for your reply. I am sharing below sample data

Modifiedon	Today
11-06-2023
11-07-2023
11-08-2023
11-09-2023
11-10-2023
11-11-2023
11-12-2023

Re: How to Show Delta Between TODAY() and Modified Date formatted as Days in Dax

FreemanZ — Wed, 06 Dec 2023 14:47:10 GMT

hi Gopal_PV ,

not sure if i get you, supposing you have a data table like:

Date

8/1/2023

9/1/2023

10/1/2023

11/1/2023

12/1/2023

12/2/2023

12/3/2023

try to add a calculated column like:

Column = VAR _diff = DATEDIFF([date], TODAY(), DAY) VAR _result = SWITCH( TRUE(), _diff>90, ">90 days", _diff>60, "> 60 Days and <= 90 Days", _diff>30, "> 30 Days and <= 60 Days", "<=30 days" ) RETURN _result

it worked like: