Fun With dates

[CityZ3n]

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?

[Ritaf1983 · Accepted solution]

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/1447523

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[CityZ3n]

Thanks

Thats exactly what I need.
Been looking at it so long today I have mushed my brain 😁

When i googled I wasn't using multiple dates as a parameter so i wasn't getting the right answers.

Much appreciated.

[Ritaf1983]

That's what we're here for, feel free to ask 🙂