Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am trying to get the Number of Days between two Dates, then if <= 30, I want the Original Amount to show in the New Current Column. If >= 30 AND <=60, then the Original Amount show in the New 31-60 Column. I'm not getting any DAX error using the below info, but it's showing the Original Amount in both Columns. What am I doing wrong? Any help would be appreciated.
Solved! Go to Solution.
Hi @ktipton ,
According to your description, here’s my solution.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ktipton ,
According to your description, here’s my solution.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This was exactly what I needed. THANK YOU so much!!
Hi @ktipton
Try these codes to add those columns:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
@ktipton you can simply do this and DAX will comply
but to answer your question
_dateDiffDateDay = DATEDIFF('Table'[Column1].[Date],'Table'[Column2].[Date],DAY)
with this DAX does exacty same as
'Table'[Column2]-'Table'[Column1]
_dateDiffDayDay = DATEDIFF('Table'[Column1].[Day],'Table'[Column2].[Day],DAY)
with thi DAX is only subtracting the DAY part (31-1),(30-1)
pbix is attached
Thank you for the info, but what I'm trying to do is have DAX calculate the DAYS between Invoice Date and New Date Paid off. Once it gets those days, if <= 30, then I want to take the Original Amount and it put it in the New Current Column.
For the New 31-60 Column, I want DAX to determine the days between Invoice Date and New Paid Off Date and if GREATER >= 31 and <=60 DAYS, then it would take the Original Amount an add to this new column New 31-60.
When I do my DAX queries above, I get the same amount in each aging bucket column, but I was hoping DAX could determine the days between then move the Original Amount into the correct column:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
22 | |
17 | |
17 | |
11 | |
7 |
User | Count |
---|---|
27 | |
26 | |
13 | |
12 | |
12 |