Forum Discussion
Cashflow from two different tables
ITManuel , Have you created a common date table using calendar and joined with both tables. Same is true for other common dimesnions.
Create a date table with month, qtr, year and other required columns
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
ITManuel , Have you created a common date table using calendar and joined with both tables. Same is true for other common dimesnions.
Create a date table with month, qtr, year and other required columns
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
Hi amitchandak,
great help, thanks. The solution with the common date table worked fine.
Now I have another small issue. I created the chart (as below). The line charts are the calculated running totals of IN and OUT. The line chart for IN appears interrupted because of misssing values on the common date x-axis. Is there a way I can connect the line?
In In formula add +0
Like
Count(IN) +0
Ok, thanks.
Then empty spaces go to "0" and line is connected, but I would like to have the line connected from one value point to the other.
