Forum Discussion
tkavitha911
Helper III
Helper IIIneed help this calculated table by using dax
Could you please help me create a calculated table in Power BI using DAX? I have two tables: Calendar and Inbound_Query. The Inbound_Query table includes the following columns: Market, Supply Catego...
tkavitha911Helper III
Helper IIINeed to fixpending containers and Total containers pls help
im providing the sample data and out put both
| Market | Date | Max eta date | No of containers arrived | Capacity | Clearence days | No of containers deliverd | No of containers pending to deliver | Total containers |
| India | 11-11-2024 | 11-11-2024 | 23 | 5 | 3 | 5 | 18 | |
| India | 12-11-2024 | 12-11-2024 | 24 | 5 | 3 | 5 | 37 | 42 |
| India | 13-11-2024 | 5 | 3 | 5 | 32 | 37 | ||
| India | 14-11-2024 | 5 | 3 | 5 | 27 | 32 | ||
| India | 15-11-2024 | 5 | 3 | 5 | 22 | 27 | ||
| India | 16-11-2024 | 5 | 3 | 5 | 17 | 22 | ||
| India | 17-11-2024 | 5 | 3 | 5 | 12 | 17 | ||
| India | 18-11-2024 | 5 | 3 | 5 | 7 | 12 | ||
| India | 19-11-2024 | 5 | 3 | 5 | 2 | 7 | ||
| India | 20-11-2024 | 20-11-2024 | 3 | 5 | 3 | 5 | 0 | 5 |
| India | 21-11-2024 | 21-11-2024 | 5 | 3 | 5 | -5 | 0 | |
| India | 22-11-2024 | 22-11-2024 | 5 | 5 | 3 | 5 | -5 | 0 |
| India | 23-11-2024 | 23-11-2024 | 5 | 3 | 5 | -10 | -5 | |
| India | 24-11-2024 | 24-11-2024 | 5 | 3 | 5 | -15 | -10 |
Hi tkavitha911,
Blank values in your input columns do affect measures, especially when doing cumulative or row-by-row logic.
Attached pbix file for your reference
Regards,
Vinay Pabbu