March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
We want to calculate the difference in seconds between the two dates( start and end) selected from a slicer. As we are very new to this could anyone please help us out?
Thank you,
Nikhil Pranav
Solved! Go to Solution.
Hi @nikhil893,
PorkChop's DAX expression works fine.
Measure = DATEDIFF(MIN(Sales[Date]),MAX(Sales[Date]),DAY)&" Days"
Regards,
Charlie Liao
Hey dude.
If you are doing this in dax it's super simple.
=DATEDIFF([Startdate],[EndDate],second)
@PorkChop : We need to have the start and end dates to be selected from the user using a slicer. Will this measure work for that too ? We do not have any columns named ' Start date' and 'end date'. We have only one column as date which we are using in a slicer.
Hi @nikhil893,
PorkChop's DAX expression works fine.
Measure = DATEDIFF(MIN(Sales[Date]),MAX(Sales[Date]),DAY)&" Days"
Regards,
Charlie Liao
*flexes*
Interesting, maybe you could try
=DATEDIFF(min([DATE]),max([DATE]),second)
where [DATE] is the columnname of the slicer you are using?
@PorkChop : The DATE coulmn may have dates from 1 Nov 2016 till 30 Nov 2016. The selection from the slicer could be 2 Nov (start date) and 4 Nov (End date). We need these two dates ( 2 Nov and 4 Nov) , not the min and max dates in the date column. Will this measure work for that ?
Well i've not tested it i practice but it should do. When you are filtering using the slicer, it's actually like creating a new table of entries between those two dates. If we then pick the smallest and largest values in that table it's the same effect.
You'll want to test it, as I haven't but syntactically should be correct.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
90 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |