Forum Discussion

inti's avatar
inti
Regular Visitor
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Inti,

     

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

     

    To help you, I'm making these assumptions:
    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:


    newcolumn = DATEADD('Tablename'[tb1], [ppc], DAY)

     

    Hopefully this solves your question. Please mark this answer as a solution if it does!

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Inti,

 

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

 

To help you, I'm making these assumptions:
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:


newcolumn = DATEADD('Tablename'[tb1], [ppc], DAY)

 

Hopefully this solves your question. Please mark this answer as a solution if it does!