Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Selecting the time passed from a date

I´m getting asked a weird requisite. We have a database containing customer who are in debt. Each row is a different customer, and each customer has a paying deadline, in a date column. I´m getting a...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

    Create a calendar table and use the date of the calendar table as a slicer. And control the slicer to single selection.

    Then to create a measure as follows:

    Measure 3 = 
var _datediff=DATEDIFF(MAX('Table'[Date]),SELECTEDVALUE('calendar'[Date]),DAY)
var _if=IF(HASONEVALUE('calendar'[Date]),_datediff,"Only one date can be required")

return _if

    Result:



    Please refer to the attachment below for details. Hope this helps.

     

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Assume you need 2 months passed the deadline, For that, you can have a what if parameter.

 

calculate(countrows(table), filter(Table, Table[Deadline] <= date(year(today()), month(Today()) -[whatif measure] , day(today()) ))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How should the "whatif" measure be done?