Calculate seconds based on 2 dates

Anonymous ,

Let's see if this can help you out. I attached the pbix file below. But here's a few bullet points of what I did:

• Created two parameters. One for Date0 and one for NumOfDays
• Created a table that will have the Date and Time now
• Added two custom columns that will take the total seconds from Date0 and the date today and then one that will use the NumOfDays parameter to offset the Date today and then givet those total seconds.

Here's the M code:

let
    Query2 = #table(
    type table
    [
        #"Now" = date
        
    ],
{
    {DateTime.LocalNow()}
    
}

),
    #"Added Custom" = Table.AddColumn(Query2, "StartSeconds", each Duration.Days (  Date.From( [Now] ) - Date0) *24 *60*60, Int64.Type),
    #"Added Custom2" = Table.AddColumn(#"Added Custom", "EndSeconds", each Duration.Days (Date.From ( [Now] ) + #duration( NumOfDays,0,0,0) - Date0)*24*60*60, Int64.Type ),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom2",{"StartSeconds", "EndSeconds"})
in
    #"Removed Other Columns"

and then the final table

Here's the pbix file:

https://1drv.ms/u/s!Amqd8ArUSwDS00jGX8xV_zSn2zEX

Hope it helps

-Nick

I was able to accomplish what I needed y just calculating the values like below.

BegSecValue = (Duration.Days(Date.From(DateTime.Date(DateTime.LocalNow())) - Date.From("1/1/1970")) -1) *24 *60*60,
EndSecValue = (Duration.Days(Date.From(DateTime.Date(DateTime.LocalNow())) - Date.From("1/1/1970")) +1) *24 *60*60,

Another issue - I am unable to figure out how to sort this matrix based on the date ranges below.  I have tried a custom sort buat that did not seem to work. Any ideas?