PowerBI "Select Group By" on exsisting table


Sometimes we need to calculate things different. Gere you will find an example for takeing over an exsisting table we already imported to PBI. and then as the 2nd step we need to calculate sum with group by. This is the base script:   Recodings Per Month = SUMMARIZE ( 'Invoice Line Item', ('Invoice' ), 'Item', "Recording ", SUM ( 'Invoice Line Item' ) ,"yyyymm", left('Invoice' ,6) )   attached you will find a PBIX sample
תגיות: ,
אין תגובות