Reply
Mab Frequent Visitor
Frequent Visitor
Posts: 9
Registered: ‎01-11-2019
Accepted Solution

new calculated column using dates

Hi,

I need to calculate max expected lag = today()-[no of lag days] and get a date answer as the output. However I keep getting 43743 type text and I am unable to convert this into date.

When I create the calculation using DAX, this new column doesn't show up in the query editor and I am unable to convert the data type.


Accepted Solutions
Frequent Visitor
Posts: 16
Registered: ‎05-15-2018

Re: new calculated column using dates

Try this:

Date.AddDays(DateTime.LocalNow(), -1 * [no of lag days])

 

And you can change the type of the custom column to Date.

View solution in original post


All Replies
Frequent Visitor
Posts: 16
Registered: ‎05-15-2018

Re: new calculated column using dates

Try this:

Date.AddDays(DateTime.LocalNow(), -1 * [no of lag days])

 

And you can change the type of the custom column to Date.

Mab Frequent Visitor
Frequent Visitor
Posts: 9
Registered: ‎01-11-2019

Re: new calculated column using dates

Today is my very first day using PowerBI. I will try creating this in DAX. but is there a way to create calculated fields in the backend/edit query window? I can only find if condition there

Highlighted
Mab Frequent Visitor
Frequent Visitor
Posts: 9
Registered: ‎01-11-2019

Re: new calculated column using dates

Thank you, that worked as a custom column