cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

DAX expression. HELP

Hi everyone, i'm new at DAX and I need to solve the following:

1. I have a table with a receipt date "tb1"

2. I have a measure that tells me the average time my client pays "ppc"

What I want to calculate is the date i'll be payed by my clients acording to the measure based on receipt date

For example, the client1 pays around 30 days after the receipt is send, the new column should sum the date on the receipt plus the average time in the measure.

1 ACCEPTED SOLUTION
Frequent Visitor

Hi Inti,

Sounds like you want to add days to a specified date. For this purpose you could use the 'DATEADD' function.

1) "tb1" is a column in the format dd-mm-yyy.
2) "ppc" is an integer, representating a number of days.

3) The result is a new column, which adds the value of "ppc" to the corresponding date in "tb1"

In the table containing your "tb1" column, create a new column in the "Home" tab. The formula for this new column would be:

6 REPLIES 6
Regular Visitor

Thank you very much for all the help provided. I have found a solution.

Community Support

Hi @inti

Can you  provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

Regular Visitor

Yes, the expression is great! But now i'm learning that there is a circular reference between "ppc" and the date column "tb1"... actually the "ppc" measure uses the same column to calculate the interger output.

How can i ad a filter or solution to this?

Frequent Visitor

Could you give me the DAX for the "ppc" measure? You might be able to use other data/other columns to achieve your goal.

Regular Visitor

Yes, of course:

``````PPC = CALCULATE(
DIVIDE(SUM(IMPUTACION_VTA[NUMERAL]),SUM(IMPUTACION_VTA[IMPORT_CAN]),0),
CLIENTES[AREA]<>"M",
CLIENTES[AREA]<>"L",
CLIENTES[AREA]<>"V"
) ``````

I already tried to encapsulate the "PPC" measure declaring a variable and changing the table to extract the date ("imputacion_vta" for "saldo_cta_cte hist") but no success

``````Payment forecast =
VAR ppc_valor = [PPC]
RETURN
CALCULATE(
ppc_valor,
FILTER(
'SALDO_CTA_CTE HIST',

I'm creating this column in the "Imputacion_Vta" table, ¿Can this be the problem?

The table that reflect our ERP data is "Doc_Vta_Cab"

The table is used to create many calculated columns is "Imputacion_Vta"

PPC is a measure

Relations between tables:

"Imputacion_Vta" many to one with "Doc_Vta_Cab",

Cross filter direction: both,

Relation active checkbox: true

Frequent Visitor

Hi Inti,

Sounds like you want to add days to a specified date. For this purpose you could use the 'DATEADD' function.

1) "tb1" is a column in the format dd-mm-yyy.
2) "ppc" is an integer, representating a number of days.

3) The result is a new column, which adds the value of "ppc" to the corresponding date in "tb1"

In the table containing your "tb1" column, create a new column in the "Home" tab. The formula for this new column would be:

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors