Forum

Salut Gigi, If you don't have access to source data, all you can do is export data, there is no connector to PBI online in power query.

Hi Mike, This shows indeed a list of files, but you have to filter the list for xlsx file extension, then add a column with the formula Excel.Workbook...

Can you please upload a sample file with anonymized data? Thank you

I think you should check the measures, if there is no fact data for a specific period, those periods should be automatically removed by pivot. For ...

Hi Quynh, Can you provide a screenshot of your data model?

Hi Amanda, Might be more difficult to do that in excel, should be easier in power BI. Here is a tutorial on this subject: Or:

Hi Katie, It's an old issue, see more details here:

No. You have to answer a simple question: On what field you need the running total to be applied? That is the field you need to drag into the meas...

Hi Vijay, Quite a lot of questions, you should try a single question per topic, I'll reply to the easiest one :). =SUM("Component",Data!C5:M5) w...

Hi Peter, Thanks for spotting that, we'll fix that in next version.

Hi Danielle, Rolling 3, or 12 months should be easy: Rolling3Month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX(Sales[Sa...

Hi Nate, Select the column you wish to sort by hierarchy. Click on the “Sort Ascending” or “Sort Descending” icon in the column header. Choose the ...

Hi Nate, The running total measure, like ANY measure, will need a field from a data table. You can't use filters for running totals or any measure.

Attached an example. You should learn at least the basics of Power Pivot before creating reports, here is a video that can get you started:

Hi Yen, You can add a new measure in Power Pivot, not in Power Query. I don't know the math behind your data, what formula are you looking for?