Forum Discussion
Anonymous
7 years agoNot applicable
DAX Function To Compare 3 Different Dates-Timestamps Columns
Hi, Am using Powerpivot and I have 3 columns, each with date & time scans in them. The 3 columns occur in the exact sequence as shown below: (i.e. Job booking date occurs first, then Attempted Ac...
- Anonymous7 years ago
Yes that worked and powerpivot does include = at beginning by default.
Sorry its my first time seeing such a long formula and didn't know you could include variables in a formula which is awesome.
Thank you again for your help, much appreciated:)
- Anonymous7 years ago
AlB its ok I've managed to fix issue myself after some manual testing. Thanks again:)
Anonymous
7 years agoNot applicable
Hi AlB yes we did and the formula worked fine but as per my last message, the output result did not look right as it was heavily skewed based on over 72k rows of data. I attached full dataset in my last message and just curious if you were able to replicate it from your end. But if not possible, then its ok. Sorry for the trouble. Appreciate your help thus far.