Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hola
Me gustaría tener una condición en la que en si BILLING_PERIOD seleccionado es < marzo 2020 se mostrará el PAGO REGULAR más se mostrará el PAGOS NO REGULAR. He creado una columna con para esto usando la instrucción IF.
Esta es mi fórmula:
Sin embargo, im tener este error cuando lo arrastro en mi gráfico de barras.
@icdns , Está comparando la fecha con un mes. debe ser mes año columna
REGULAR_NON_REGULAR_COLUMN IF(FACT_PYMTS[Month Year] < "March 2020", FACT_PYMTS[REGULAR_PYMT_TIME], FACT_PYMTS[NON_REGULAR_PYMT_TIME])
o formatear y obtener
REGULAR_NON_REGULAR_COLUMN IF(format(FACT_PYMTS[DATE],"MMMM-AAAA") < "March 2020", FACT_PYMTS[REGULAR_PYMT_TIME], FACT_PYMTS[NON_REGULAR_PYMT_TIME])
REGULAR_NON_REGULAR_COLUMN IF(FACT_PYMTS[DATE] <date(2020,03,01) , FACT_PYMTS[REGULAR_PYMT_TIME], FACT_PYMTS[NON_REGULAR_PYMT_TIME])
Si es una medida
REGULAR_NON_REGULAR_COLUMN- IF(format(max(FACT_PYMTS[DATE]),"MMMM-AAAA") < "March 2020", FACT_PYMTS[REGULAR_PYMT_TIME], FACT_PYMTS[NON_REGULAR_PYMT_TIME])
Ambos deben tener un tipo de datos similar FACT_PYMTS[REGULAR_PYMT_TIME], FACT_PYMTS[NON_REGULAR_PYMT_TIME]
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 @AllisonKennedy ,
2: ¿Cuál es el tipo de datos de FACT_PYMTS[Fecha] ? Su DAX Indica que es texto, en cuyo caso no puede utilizar < "Marzo 2020" por lo que necesita cambiar eso a < DATE(2020, 03, 01) - Ya lo cambio a Fecha, ¿debo usar < DATE(2020, 03, 01) ?
3: ¿Cuál es el tipo de datos para los tipos de pago regulares y no regulares y qué tipo de gráfico está utilizando? - El tipo de datos de mis pagos regulares y no regulares es TEXTO. Y sólo estoy usando un gráfico de barras 🙂
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
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,AllisonKennedy,
Estoy usando la consulta directa para esto y es por eso que SELECTEDVALUE no está funcionando 😞