Forum Discussion
Michael_nik
3 years agoRegular Visitor
Making a pivot table
Hi everyone! I'm new in power bi, but I have a strong basis in Pyton. I was given a simple task to make a table from sample one which is given in Power BI by default. So the task is to calculate ...
- 3 years ago
Use this measure:
Gross Sales by min Sale Price = VAR _minPrice = MIN ( financials[Sale Price] ) VAR _MinPriceAll = CALCULATE ( MIN ( financials[Sale Price] ), ALL ( 'Product Table' ) ) RETURN CALCULATE ( SUM ( financials[Gross Sales] ), FILTER ( 'Product Table', _minPrice = _MinPriceAll ) )
PaulDBrown
3 years agoCommunity Champion
Can you share sample data please?
- Michael_nik3 years agoRegular Visitor
To get the data, you just need to open PowerBI desktop, then choose sample data!
Hope you know how to help me, because I no longer have the strength to accomplish this task