Forum Discussion
Post PatronDifference between 2 columns in power bi
Post Patronyes i know and this is the only key which should be link .. if i get any other realtionship then same error occured..
Super UserError occured due to below reason most probably:
1) Check whether the boht the key column dont have any null values.
2) Alteast one common value should be present in both the key column.
- Tahreem24
From your data it is clearly shows that there NULL entry in key column (LPO_Key) in LPO_Excel table(Refer screen shot below) . So clear out this null values and then create one-to-many relation.
- Bakhtawar
yes i checked and also i checked from original source . .date is fine.. i just need dax command how should i get days from two dates thats it
- Tahreem24
As your both the dates are coming from two different table. So in order to find the difference between these two date you'll have to create first relationship and then create measure to subtract from both the date value.
I have created some dummy tables that matches with your requirement and it gives truly expected value. Please see the step wise details in below screen shot:
If I did answer your question,So please this as a solution.