Forum Discussion
Merge two tables with different values
I have two tables that are generated from a database, which contain the counts of invoices issued and invoices processed. In the first table, are the issued (the days column can change the values...
I solved the problem with something so basic, but that I didn't think of at the time.
Create a table with specific values, called Days and in it you add the values from 1 to 31, which are the number of days you can have a month... Next, apply the relationship between the series and invoice table and you're done!!!
Everything flowed like oil!!!
I only have to drag the columns to the visual table and without having to combine the tables or any DAX calculation.