Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to Create Single Date Filter using 3 different dates

Hi There,   Hope you are doing well,   I am trying to filter my data using single financial date/year/month however my data have three different dates. Can anyone help how to do this? E.g i hav...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Greg_Deckler,

 

thank you for your resposne .

 

Please see the attached sheet in text format 

CONCStatusR-L,CR-SLR-Sub clusterDate of JoiningMonth JoinedPN Creation DatePN Creation MonthTaleo Creation DateTaleo Creation MonthR-Campus Category
140039/PN-280780946JoinedCampusAssuranceAudit02-08-2021August01-07-2021July01-07-2021June On Campus
140068/PN-280780947JoinedCampusAssuranceAudit02-08-2021August02-07-2021July01-06-2021June On Campus
PUN001QS/PN-290679306JoinedCampusAssuranceAudit26-07-2021July05-06-2021June01-05-2021MayOn Campus
PUN001QT/PN-290679307JoinedCampusAssuranceAudit26-07-2021July07-06-2021June10-05-2021MayOn Campus
PUN001QV/PN-290679308JoinedCampusAssuranceAudit26-07-2021July10-06-2021June11-05-2021MayOn Campus
PUN001QW/PN-290679309JoinedCampusAssuranceAudit26-07-2021July11-06-2021June12-05-2021MayOn Campus
PUN001QY/PN-290679300JoinedCampusAssuranceAudit26-07-2021July12-06-2021June13-05-2021MayOn Campus
PUN001QZ/PN-290679301JoinedCampusAssuranceAudit26-07-2021July13-06-2021June14-05-2021MayOn Campus
PUN001R1/PN-290679302JoinedCampusAssuranceAudit26-07-2021July14-06-2021June15-05-2021MayOn Campus
PUN001R2/PN-290679303JoinedCampusAssuranceAudit26-07-2021July15-06-2021June16-05-2021MayOn Campus
247302/PN-290987287JoinedLateralAssuranceAudit25-10-2021October15-09-2021September10-07-2021JulyLateral
303163/PN-090985736JoinedCampusAssuranceAudit13-09-2021September16-09-2021September15-07-2021JulyCA Fresher
PUN001RL/PN-290781007JoinedCampusAssuranceAudit09-08-2021August08-07-2021July20-07-2021July0-1 year

 

As of now we have a single calendar which is working on Date of joining(only taking month), so when i click  put that into graph this is giving me Last Financial year data also as their PN Creation or Taleo Creation Month is before July, ideally it should not be dependent on pn creation or taleo creation date.
Please see below image where in first graph value should appear only upto November however it's showing data until may,june,july similarly when we go to second graph it's showing me data untill June (which is yet to come) however it should show us data untill Nov month only.

 

I hope i tried to explain what i am looking for.