Forum Discussion
Fun With dates
Hi All
I'm going around in circles with this one.
In my Data Table I have a few different date columns.
Two main ones are
Session Date & Approved Date
Most stuff runs off the Approved date
But I want to make a visual using the Session date (by Month).
When I do a Month by Month count and a Cumulative count of the Session Dates, it is grouping by the approved date.
eg - Session that was held in March is counting as June as this was the date it was approved.
I'm pretty sure I can overide the date relationship but I can't remember how.
But then again I suspect if I do that the date fileter for the report (which runs off the approved date) will probbaly break it.
Any tips or advice?
Hi CityZ3n
Please refer to the linked tutorials about handling multiple dates columns :https://www.youtube.com/watch?v=aVcHCfOAtZA
https://www.youtube.com/watch?v=r8e_bRJ07N0
For more specific suggestion
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Hi CityZ3n
Please refer to the linked tutorials about handling multiple dates columns :https://www.youtube.com/watch?v=aVcHCfOAtZA
https://www.youtube.com/watch?v=r8e_bRJ07N0
For more specific suggestion
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
