The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi experts
I have the next issue i have 2 tables A and B in table A have a row called SALDO TOTAL wich have a measure (sum) and B have another one call SALDO PENDIENTE(wich is another sum) i have created a index column to represent the months of the year in B (1 to 12)
because i need to create the follow measure
SALDO COBRADO(THIS MONTH) = SALDO TOTAL(THIS MONTH) - SALDO PENDIENTE(MONTH +1)
But i needed to diferenciate by the index number i created(i don´t have a DATE column in the DB)
so it will be like .
SALDO COBRADO ENERO(JANUARY=1) = SALDO TOTAL ENERO(JANUARY=1) - SALDO PENDIENTE(FEBRUARY=2)
I know this would be better if i would use the intelligence of time of dax but soon i will be able to make changes to my DB of the work 😃
Greetings from Perú.
Hi @Anonymous ,
Please provide sample data and desired result to help us better understand your requirement.
How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
hi i upload the bd with maskered data
https://drive.google.com/open?id=1dO_ywkjIkXbPHi0zTWXSZoG0URV3rh-f
as i post it i need a new measure that do the follow
thank u very much.
hi, @TomMartens i actually have some issue about confidenciality
but i´ll try to put images and the measures i have thanx 4 the attention
this is the structure of the data (i know is a mess but they really not know about power bi or DB stuff)
from this 2 tables i have the issue where
"facturado" is a measure created using sum(importe total) (table fact_x_docpago)
then i have another one created by the second table called "pagopendiente" another sum but using
"saldo_pendiente" and filter by "estadofactura" wich in this case is for the value "pendiente" so allways
facturado > saldo_pendiente then in the same table i created a column called MES_NUMERO (MONTH_NUMBER) to use as a index ENERO(JANUARY)=1, FEBRERO(FEBRUARY) = 2 , MARZO(MARCH) = 3.... and so.
So i need to create a UNIQUE measure that makes follows
COBRADO(ENERO) = FACTURADO(ENERO) - PENDIENTE(FEBRERO)
COBRADO(FEBRERO) = FACTURADO(FEBRERO) - PENDIENTE(MARZO)
so like it show in my visual this should show
ENERO_COBRADO = 822K - 555K =267K And so for the next months wich all are indexed
thanks for the attention