compoundcurves
New Member
- Joined
- Jul 12, 2021
- Messages
- 3
- Platform
- Windows
Hello guys! Im new to PowerBI. Ive been searching for my error but cant seem to find an answer.
I created a new Measure called "Saldo" in my Facturation table.
Saldo = sumx(FACTURACION,FACTURACION[HABERMON]) - sumx(FACTURACION,FACTURACION[DEBEMON])
This table has a date column.
My problem is when using this measure "Saldo" in a visual and using the date slicer, since they are not supported. Im trying to convert my measure to a column to use the data slicer. Would that work?
Since sumx function works differently in columns than in measures, i created the following new column :
CSaldo = FACTURACION[HABERMON] - FACTURACION[DEBEMON]
Even though using this calculated column in my visual, when selecting date ranges in the slicer the visual wont show data, it goes null.
I dont know what I can do.
Super newbie here.
Thanks in advance! ?
I created a new Measure called "Saldo" in my Facturation table.
Saldo = sumx(FACTURACION,FACTURACION[HABERMON]) - sumx(FACTURACION,FACTURACION[DEBEMON])
This table has a date column.
My problem is when using this measure "Saldo" in a visual and using the date slicer, since they are not supported. Im trying to convert my measure to a column to use the data slicer. Would that work?
Since sumx function works differently in columns than in measures, i created the following new column :
CSaldo = FACTURACION[HABERMON] - FACTURACION[DEBEMON]
Even though using this calculated column in my visual, when selecting date ranges in the slicer the visual wont show data, it goes null.
I dont know what I can do.
Super newbie here.
Thanks in advance! ?