Forum Discussion

sjehanzeb's avatar
sjehanzeb
Icon for Resolver I rankResolver I
5 years ago
Solved

Combining calendar table with calculated amount from another table in addition to customer id

This is in continuation of a Previous post.  My objective is to create a table with month wise running balance of individual customer. My transactional data is simply a list of transactions (plus/min...
Need Help
Tips and Tricks
Tutorial Requests
  • sjehanzeb's avatar
    sjehanzeb
    5 years ago
    So, I resolved it. Combine two tables with all values

    var calendertable = SUMMARIZE(Calender, Calender[Year Month])
    var SFtable= SUMMARIZE(SF, SF[ID])
    return
    CROSSJOIN(calendertable, SFtable)
sjehanzeb's avatar
sjehanzeb
Icon for Resolver I rankResolver I
5 years ago
So, I resolved it. Combine two tables with all values

var calendertable = SUMMARIZE(Calender, Calender[Year Month])
var SFtable= SUMMARIZE(SF, SF[ID])
return
CROSSJOIN(calendertable, SFtable)