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 .

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.

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        RELATED() is only something you need for calculated columns. Measures use the data model.  If your tables are unrelated then you can try TREATAS() but that may have the same Direct Query limitations.

         

        Please provide more details about your actual setup, the participating data sources, the data model etc.  It is difficult to help if the overall scenario is not clear.