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.
I know several posts have been made about this, and I have tried the strategies present in those threads. However, I'm still having issues. I think my problem is that I have the datekey of my dimension table constructed from the 'created' date, related to the datetable. The created date is part of my performance calculation and therefore the weekend exclusion is not necessarily checking each day from created to closed, but only if the created date is a weekend or not. How do I fix this? I created a sample file and attached it here, in case my summary is not clear enought. Thanks so much
Never seen such an interesting article ever; thank you very much for the great stuff dear one.
try this function with some modification it will help you Clean Master Facebook Lite Mathway
May be try something like below for calculated column?
= IF ( ISBLANK ( [Closed Date] ), COUNTROWS ( FILTER ( DimDate, [Date] >= 'sample data'[Created] && [Date] < TODAY () && DimDate[DayOfWeekNumber] <> 7 && DimDate[DayOfWeekNumber] <> 1 ) ), COUNTROWS ( FILTER ( DimDate, [Date] >= 'sample data'[Created] && [Date] < 'sample data'[Closed Date] && DimDate[DayOfWeekNumber] <> 7 && DimDate[DayOfWeekNumber] <> 1 ) ) ) + 0
@ChihiroThis is great, and much closer than I have gotten. However, the ouput is a whole number- as in it's not calculating from the date time values of the created and closed. Any ideas on how to get it to be more granular?
Hmm, I suppose you can use MOD(Now() - [Created], 1) and MOD([Closed Date] - [Created], 1), and add it back to respective calculation result (i.e True part & False part).
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |