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 there are tonns exaples here in a forum and on the web, but it seems that I find something for which I can not find a solution.
I have a fact table with dates and a tbldates table with the IsWorkingDayCode column that is set to 1 or 0 correctly.
It seems to be very easy, but I'm getting a mistake:
A column specified in the function call 'DATESBETWEEN' is not of type DATE. This is not supported
both columns are dates of fact table and are likned to tblDate
Calculated column:
Busness Days=
CALCULATE( COUNTROWS ( 'tblDate'),
DATESBETWEEN ( 'tblDate'[DateKey], V_PBI_APPLICATION_STATUS[Open Date],
IF (
V_PBI_APPLICATION_STATUS[App End Date] <> BLANK (),
V_PBI_APPLICATION_STATUS[App End Date],
TODAY ()
)
-1 ),
'tblDate'[IsWorkingDayCode] = TRUE ,
ALL ( V_PBI_APPLICATION_STATUS )
)
I was trying a lot of solutions without success.
Any appreciated help.
Thank you!
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
No, lo intenté antes. He probado su código todavía recibo el mismo error.
gracias por una respuesta rápida
¿Quieres incluir o exclusiva de las fechas de apertura y finalización? Simplemente agregue o elimine el signo igual según sea necesario en las desigualdades a continuación (como una nueva columna en la tabla V_PBI_APPLICATION_STATUS):
COLUMNA DE LA COLUMNA DE LA COLUMNA DE
VAR _maxDate - IF (
NOT(ISBLANK(V_PBI_APPLICATION_STATUS[Fecha de finalización de la aplicación])),
V_PBI_APPLICATION_STATUS [Fecha de finalización de la aplicación],
HOY ()
)
devolución
COUNTROWS (FILTER( ALL('tblDate'),
'tblDate'[DateKey]> V_PBI_APPLICATION_STATUS[Fecha de apertura]
&& 'tblDate'[DateKey]<-_maxDate
&& 'tblDate'[IsWorkingDayCode] - TRUE
)) -1
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
devuelve -1 para todas las filas.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
HOLA Allison,
Lo pensé.
Tengo otra columna en la tabla Fecha que tiene el mismo formato que La fecha de finalización y la fecha de inicio. Reenlazé estos campos y lo intenté.
Tengo el mismo error.
Puedo hacer fácilmente este n sql pero es muy frustrante no puedo averiguar esto en DAX. Soy muy nuevo en DAX.
Gracias
@vika160 - He creado Net Work Days para esto. https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109
Evitaría DATESBETWEEN - https://community.powerbi.com/t5/Quick-Measures-Gallery/To-bleep-With-DATESBETWEEN/m-p/1252805#M581
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |