Forum Discussion
How can I combine formula in Data Model
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.
Thank for your assistance
The Power Query shows correctly 100% the expect result.
How can we do it the same by Power Pivot because I want to create a pivot table from Power Pivot, that I can see details what I need.
Hope for your help
It depends on what do you have in data model. If you could share the file with it and PivotTables you generated in the sample I could try.
I have just added 3 tables into Data Model, and written some Measures.
Have a look please
https://docs.google.com/spreadsheets/d/1TOjSWsSi52OGbl5ZUxDw88bt1gPag7ld/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true
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.