Wish to have data <25

[Amardeep100115]

Hi 

I wish to have table like attached sheet in query editor , Please refer Result tab in excel sample data

Sample Data 

Please Help me on this

Result Table should be in query editor Please 

Also please share BI file once you get answer

 

[v-eachen-msft]

Hi @Amardeep100115 ,

Could you explain the logic you need to use? I am not very clear about the relationship between these tables.

[venal]

@Amardeep100115 

Thanks for sharing the PBIX file, I have downloaded and open it in Power BI Desktop.

Can you please elaborate the issue. (I have gone through the above snippet, but bit confused on which column we need to apply the condition.)

If possible please share the expected result..

[Amardeep100115]

Sure,

if you go through the data table which is main data, and the result table is the result which i am lookong into the query editor. 

"Required Table 1" is the created by grouping/pivot table in excel  and in  "Result Table Ref"  sheet i have used "IF" function to get <25 count of labe No count from "Required Table 1" in "Result Table Ref"  then again created new pivot for "Result Table Ref" and the reuslt sheet created.

i wish to create same table in query editor with using data sheet. 

i tried to create same  in "Required Table 1" but the end result are showing wrong value. 

results should be like above snap/Result sheet in excel file.

Hope i am clear on my question.

Please help

[Amardeep100115]

Can any one try to help me on my query

[v-eachen-msft]

Hi @Amardeep100115 ,

You could open query editor and pivot the column 'Result Table Ref'[<25 HC ].

Then you could use the SUM () function to add Y and N and create a new column.

[Amardeep100115]

I tried but the results of the column is not show exact what i am looking for 

i used DATAFLOW to get connected data source

still looking for help

[Anonymous]

The Data file you attached is too big to open (>5MB)

Eric Ji | Senior Business Intelligence Consultant
www.designmind.com

[Amardeep100115]

Power BI File 

Please finds the pbix file 

it has all sheets which is in excel data