This is the situation:
I have a report which shows a matrix with items where each item got an id.
In addition each row also contains 2 columns
where each shows the sales of the item for 2 seperate years.
Here is the DAX which is being used for those sales:
sales for specific year =
CALCULATE(
'measure for sales',
FILTER(
'table',
'table'[document date].[year] = SELECTEDVALUE('extra table for selected year'[year])
)
)
DAX for measure 'measure for sales':
measure for sales = SUM('table'[sales])
There is also a additional column which contains a description of the item.
Lastly I created a Power Automate button to activate a flow
which takes the data of all 4 columns and exports them into a excel file.
I tried it in two different ways:
1. I created a excel file in One Drive with a table
(4 column heads which have the same names as the column names provided by the Power BI data).
Here comes the step for Power Automate: 'Add a row to a table' (target excel file in One Drive and iterate over Power BI table)
2. I created an empty excel file in One Drive which is empty because it only exists as a template.
Steps for Power Automate: 'Select'(all data of Power BI table entered into map);
'get file content'(One Drive; content of empty file);
'create file'(One Drive; content is the "body" from the previous step);
'create table'(Excel; file is "ID" of the previous step "create file");
'apply to all'
(iterate over "output" of the step "Select";
"add row to table"(file is "ID" of step "create file"; table is "name" of step "create table"; row is "current element" of "apply to all"))
Here comes the problem:
Nothing went wrong of using the first method
but I needed the second dynamic method to always be able to create an excel file.
As I tried the flow, I got the sales but with a different amount of decimal places compared to the sales I got from the first method.
For example I obtained a sales of 32.689,35 for the first method but in the second method I obtained 326.893.533.
So basically I the decimal places of sales got moved by 4 places to the right side.
How is that even possible?
Is there anything wrong with my measure?
I even configured the measure with type currency and a max decimal place value of 2.
I even configured the data of 'table'[sales] to be of datatype 'fixed decimal number'.
Any hints to solve this problem would be appreciated.
