Forum Discussion

jedsh08's avatar
jedsh08
Frequent Visitor
4 years ago
Solved

Get information based on date range

Hello ,  I am really new to the world of data and also with power bi. I am trying to do a comparison between information on date ranges.  I am pulling out 07 days information (Friday to Thursday) w...
Need Help
  • jedsh08's avatar
    jedsh08
    4 years ago

    Thank you it helps .

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, jedsh08 

 

I simply simulated some data hoping to restore your problem.

Date2 = DATEADD('Table'[Date],-7,DAY)
Value2 =
LOOKUPVALUE ( 'Table'[Value], 'Table'[Date], [Date2] )

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

 

Best Regards,

Community Support Team _Charlotte

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

jedsh08's avatar
jedsh08
Frequent Visitor
4 years ago

After trying what you have said, I understand that it will work, but I have another problem when applying your solution. I am connected in DirectQuery mode and when trying calculate columns, I cannot find the LOOKUPVALUE() function. 

Can you tell me what's wrong? 

Thanks for your help.

  • jedsh08's avatar
    jedsh08
    Frequent Visitor
    4 years ago

    Is it normal? 

      • jedsh08's avatar
        jedsh08
        Frequent Visitor
        4 years ago

        Will I use the Related() function in this case? I also want to mention that my result column (based on the 7 selected days) is a measure Dax and I indicated that I cannot include a measure in another measure.