Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
henrique0galli
Helper I
Helper I

new query from table

‎05-13-2018 04:32 PM

How can I create a new query based on a generated table (based on other tables I had imported from Excel files).

 

 

Capture.PNGUntitled.png

Labels:
Message 1 of 13
2,356 Views
0
2 ACCEPTED SOLUTIONS
henrique0galli
Helper I
Helper I
In response to henrique0galli

‎05-13-2018 08:42 PM

Would LOOKUPVALUE be the best function for this scenario?

 

Thanks again

 

 

**** SOLUTION UPDATE ****

 

It was not able to create New Query based on the generated New Table. So managed to solve with this function:

 

ColumNew = LOOKUPVALUE(tbl_Averages_as_tabular[Usage Forecasted],tbl_Averages_as_tabular[Works Type],tbl_Future_Allocations_Plannned[Works Type],tbl_Averages_as_tabular[Item],tbl_Future_Allocations_Plannned[Item])

View solution in original post

Message 9 of 13
2,382 Views
Phil_Seamark
Employee
Employee
In response to henrique0galli

‎05-13-2018 11:54 PM

Hi @henrique0galli

 

This would be more efficient as a calculated column and I have attached a PBIX file to demonstrate

 

New Column = 
    MINX(
        FILTER(
            'tbl_Averages_as_tabular',
            'tbl_Averages_as_tabular'[Item] = EARLIER('tbl_Future_Allocations_Plannned'[Item]) &&
            'tbl_Averages_as_tabular'[Works Type] = "Btoc"
            ),
            [Usage Forecasted])
To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

allocations.pbix
Message 12 of 13
2,423 Views
0
12 REPLIES 12

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All