Forum Discussion
Solved
How can I combine formula in Data Model
Hi, I am trying to combine data from Data Model into a Pivot Table , I have written some Measures but it hasn't shown the expect result. I have added an image and the link of the Samplefile below ...
If build relationships as
your PivotTable gives practically desired result.
The only it's better to use
perc late A:=DIVIDE( [Total late], [Total ontime], BLANK() )instead of
perc late:=[Total late]/[Total ontime]As third parameters in DIVIDE you may use whatever you want instead of BLANK().
Another point we have blank for hub areas, that means not all areas appears in Table1 and Table2 are in Table3. But that's better to adjust Table3.
Please check in attached file.
Alternatively, to create a formula that uses a function, click the “Design” tab in the data model window's Ribbon. Then click the “Insert Function” button in the “Calculations” button group to open the “Insert Function” dialog box. Then select a function in the listing in this dialog box
Hope this helps
Hope this helps
Thank you