Forum Discussion

Penn's avatar
Penn
Resolver I
7 years ago
Solved

DATEDIFF Difference

Hi Everyone,   I have three calculated columns, and the last one is a calculated column to compare the date diff of the first two.   The result looks very normal in model tab, for example   Ite...
Need Help
  • edhans's avatar
    edhans
    7 years ago

    It would be on that field dropdown. It may not be first/last. I was looking at another model with text. But could be min/max, which would be the same in this case.

     

    Not a big fan of this approach, as I prefer measures, but seeing if we can get you what you want without starting over with where your data calculations are.

     

Penn's avatar
Penn
Resolver I
7 years ago

Hi edhans 

 

Can you explain more about the first option? How to get it not summarize that data in the data setting for that field. And how to set to FIRST or LAST? Thanks

edhans's avatar
edhans
Community Champion
7 years ago

It would be on that field dropdown. It may not be first/last. I was looking at another model with text. But could be min/max, which would be the same in this case.

 

Not a big fan of this approach, as I prefer measures, but seeing if we can get you what you want without starting over with where your data calculations are.

 

  • Penn's avatar
    Penn
    Resolver I
    7 years ago

    Thanks! edhans 

    The DAX works fine and I will look into the first option