Forum Discussion

P_B's avatar
P_B
Frequent Visitor
6 years ago
Solved

Create Calculated Column - Difference between two columns and exclude certain rows

I am trying to create a new column Days to review.    Days to Review = Posting close date - Actual Date.    Not sure how to perform this in DAX (I am new to Power BI) - I tried regular subtractio...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi P_B 

    In Edit queries, change data type as "date",

    the "N/A" field will become "error", 

    Replace error with null

    File->Close&&Apply

    You could create a column

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi P_B 

In Edit queries, change data type as "date",

the "N/A" field will become "error", 

Replace error with null

File->Close&&Apply

You could create a column

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.