Forum Discussion
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...
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!
Thank you very much for all the help provided. I have found a solution.