Forum Discussion
homboy27
Helper III
Helper IIICreating excel tables from Published PI Reports
I have a dashbaord that is published on power bi workspace. I have then created tables from the dashboard by linking to the powerbi workspace. Once I refresh the powerbi, I open the excel and refresh...
Does this already exist in your dataset as a Measure? if not then try creating a Measure like
Total Sales =
SUM ( Table[SalesAmount]first in the dataset. That way the calculation is handled by the dataset, and Excel will respect it
MasonMA
Super User
Super UserDoes this already exist in your dataset as a Measure? if not then try creating a Measure like
Total Sales =
SUM ( Table[SalesAmount]
first in the dataset. That way the calculation is handled by the dataset, and Excel will respect it
homboy27Helper III
Helper IIIyes it already exisits in my data set as a column. who does that it not work if its already in the dataset?