Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts,
how do i get the dax for no of days from the date slicer?
I wanted to show the count between below date range and i dont want to use relative date. Once i get the count of days then again i need to calculate 3*1440(how iam this number is 24hrs in a day and 60minutes per hour so 24*60=1440)
I tried min, max, selectedvalue but no luck. Could you please help me someone
Below is the actual requirement from customer and GPH is a measure
Regards,
Venkat
Solved! Go to Solution.
@Anonymous You should be able to do:
Count Measure = ( MAX('Dates'[Date]) - MIN('Dates'[Date]) ) * 1.
@Anonymous You should be able to do:
Count Measure = ( MAX('Dates'[Date]) - MIN('Dates'[Date]) ) * 1.
@Greg_Deckler i tried already without multiplication 1 and now i tried as you said but no luck and even i tried with countrows that also not working
Regards,
Venkat
@Anonymous So, what is the purpose of the 2 slicers?
@Greg_Deckler Just for illustration purpose only showed relative date slicer. Only required Date slicer.
Can anyone help me on the dax? @MFelix @amitchandak @Ashish_Mathur any help here
Hi @Anonymous ,
I have made a test and all the metrics refered here work properly, no issues on the calculation, believe that you may have some relationship, or context filter that is causing this calculation to not work.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@Greg_Deckler Thank you greg. its working both solutions after i reviewed joins.
@MFelix Thanks Felix for your valuable suggestions
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
62 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |