logic similar to previousday

[RG007]

Hi All,

I have a Date table with DateKey and Date , alt_Date (3 Columns)

Here alt_date also had date ,but it has  random date, while date is like regular date fields in any date dimension.

another Sale table

that has 

DateKey, Sale_Amount (two columns)

Both table are joined on Date_key

I want to create a report with 

Date, Sale(on Date, sale(on alt_date)

first two are simple, just drag and drop, I am having hard time to have sale on alt_Date.

Can somebody please advice.

Thanks

[amitchandak]

@RG007 , First table you have to also join on alt_date. That will be inactive join.

You need to use that in a measure using userelation 

refer my Hr video How to use: https://youtu.be/e6Y-l_JtCq4

Or this blog - https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[RG007]

Hi I tried userelation, I used that many times before also , but in this case it didn't help me.

[RG007]

Please find attached picture for my need.

[Ashish_Mathur]

Hi,

In the Sale Table, don't you have a Date column?

[RG007]

No, Sale table has only dt key...Thanks

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[RG007]

Great..Thanks

[Ashish_Mathur]

You are welcome.

[Greg_Deckler]

@RG007 Sorry, having trouble following, can you post sample data as text and expected output? 

You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

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.