Forum Discussion
Correct date with Dax multiple records
Hi Anonymous ,
I'm sorry, but despite your explanation, I still don't understand what you mean
How do you get 4 for the number of days? From what calculation? Why is it 4, is it 2022-2018=4?
How do you explain the number of days for Danielle Food? I don't understand on what basis you calculated it?
Why does the number of days for Deanna Run become 5?
That's weird!
Could you please provide more details?
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous There is no calculations. The number is in the table above its the 4th column highlighted in yellow called # of Days. This number changes based on the Target Start and End Date the 6th and 7th column in the table. For Danielle Food 1st Target Start Date is on the 6th row and Target Start Date is Nov 16, 2021 to Target End Date Mar 13, 2022 and is 3 which is what I want to return on a graph for 2022 from Jan 1, 2022 - Mar 13, 2022.
Then the 5th row the Target Start Date is Mar 14, 2022 to Target End Date Mar 15, 2022 and is 2.5 which is what I want to return on a graph for 2022 Mar 14, 2022 - Mar 15, 2022. Then on the 4th row is Target Start Date of Mar 16, 2022 and No Target End Date but this target is active per the Target Status (8th column) meaning on a graph of 2022 I want to use now its 3 so from Mar 16, 2022 to current date I want 3.
I want if possible a formula that would be able to grab the correct # of Days (column 4) using the table based on the Target End Date (Column 6) and Target End Date (Column 7).
Hi Anonymous ,
Could you please provide a simple sample (without privacy information) and desired output (It is best to use images to represent your example data and the desired output separately).
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous I needed it to be daily so to get it to fit I broke it into quarters. Here is the desired result I am looking for. I color coded the changes which are according to the first table above.
Happy to provide any further information that is needed just let me know.