Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with Adding Days in Direct Query and Null Entries in a Date Column

All columns are underlined!!   So I have a query that has a list of customer orders. There is a Desired Ship Date column and I am trying to make a report that only displays orders within the next 9...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    You can go to report view,using dax expressions to realize it.

    Create 2 measures as below:

     

     

    90 Days From Today = TODAY()+90
    Orders Within 90 Days = IF(MAX('Student'[sDate])>=TODAY()-90&&MAX('Student'[sDate])<=TODAY(),MAX('Student'[sDate]),BLANK())

     

    Or you can create 2 calculated columns as below:

     

    _90 Days From Today = TODAY()+90
    _Orders Within 90 Days = IF('Student'[sDate]>=TODAY()-90&&'Student'[sDate]<=TODAY(),'Student'[sDate],BLANK())

     

     

    Finally you will see:

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

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

Hi Anonymous ，

 

You can go to report view,using dax expressions to realize it.

Create 2 measures as below:

 

 

90 Days From Today = TODAY()+90
Orders Within 90 Days = IF(MAX('Student'[sDate])>=TODAY()-90&&MAX('Student'[sDate])<=TODAY(),MAX('Student'[sDate]),BLANK())

 

Or you can create 2 calculated columns as below:

 

_90 Days From Today = TODAY()+90
_Orders Within 90 Days = IF('Student'[sDate]>=TODAY()-90&&'Student'[sDate]<=TODAY(),'Student'[sDate],BLANK())

 

 

Finally you will see:

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!