Forum Discussion

tkavitha911's avatar
tkavitha911
Icon for Helper III rankHelper III
1 year ago

need 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...
urgent help needed
tkavitha911's avatar
tkavitha911
Icon for Helper III rankHelper III
1 year ago

The balance containers need to be carried forward to the next day, even though the input data does not have continuous dates

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi tkavitha911,

 

As per my analysis, the solution provided by Jihwan_Kim  matches the requirement.

However, to assist you further and provide an accurate and working solution, could you please help clarify a few things:

  1. Date Context: Is the expected output a daily view across a calendar, or are we only interested in dates that appear in the Max ETA date column from the Inbound Query table?
  2. When you say you want "carried forward to the next day," in which column do you want the day to be carried forward?
  3. Please provide a sample data/ pbix to get more clarity about your situation.

Your explanation will give us more clarity and hence we would be able to assist you better on this.

 

Regards,

Vinay Pabbu