Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help Converting an Excel countifs function into Power BI

Hi all,   I am new to the forum and new to Power-Bi and I really need a little help.   I have been given an excel sheet and asked to convert it to Power-Bi. I am really stuck with 1 formula in pa...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi Anonymous,

 

This should be possible with a calculated column formula.  Share the link from where i can download your file.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

Thanks guys for taking the time to have a look and try to help :)

 

 

Please try this link to the excel file. https://1drv.ms/x/s!AraHh-vwAl8dgU2WZDIaPRQmV0Bq

 

and this link for the extract from Powerbi. https://1drv.ms/x/s!AraHh-vwAl8dgVE6xMUtsW9SsAQH   

 

I have managed to add an order line count. i still need the last 2 columns from the excel sheet adding to PowerBi .

The Table i am using in PowerBi is called Orderwell Summary.