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.
Hi guys.
I have 2 tables. One is the DimDate table where I have the Non-working days column, Saturdays and Sundays (0 Weekly, 1 Non-working). The other GTI Table where there are 2 columns with 2 dates: Creation date and expiration date. Both tables are linked.
In the GTI table, I'm calculating how many Saturdays and Sundays there are between Creation date and expiration date:
FDS = CALCULATE (SUM (DimDate [DiaLaboral]); FILTER (DimDate; DimDate [Date]> = FIRSTDATE (GTI_POWERBI [Creation Date]) && DimDate [Date] <LASTDATE (GTI_POWERBI [End Date]))).
This works very well for me but when the Due Date is a Monday, the previous weekend does not count it (Case 1 in Red) but I have another date if it does (Case 2 in blue).
In the image, the result of case 1 must be 10 and not 8. But case 2 is correct and both end on a Monday.
Can you help me?
Case 1: It´s wrong
Case 2: Its Ok
I appreciate your help. Sorry for my English
Solved! Go to Solution.
Hi, you can use a calculated column with:
FDS = CALCULATE ( SUM ( DimDate[DiaLaboral] ), FILTER ( DimDate, DimDate[Date] >= GTI_POWERBI[Fecha de Creación] && DimDate[Date] < GTI_POWERBI[Fecha de Vencimiento] ) )
Regards
Victor
Lima - Peru
Hi, you can use a calculated column with:
FDS = CALCULATE ( SUM ( DimDate[DiaLaboral] ), FILTER ( DimDate, DimDate[Date] >= GTI_POWERBI[Fecha de Creación] && DimDate[Date] < GTI_POWERBI[Fecha de Vencimiento] ) )
Regards
Victor
Lima - Peru
Excelente Vvelarde.
Muchas gracias. Funcionó perfecto
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |