Forum Discussion

Topjacket's avatar
Topjacket
Icon for Helper I rankHelper I
1 year ago
Solved

Summarize 2 Columns with all possible options

Hi   I have added a new table using SUMMARIZE. All seemed to be working fine but I have just realised that some "Customers" do not have all dates which I need to display.    Is it is possible to ...
Summarize Columns
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    Hi Topjacket  Using crossjoin, you would be able to create all kinds of possible combination. Try below code:

    DesiredTable = 
CROSSJOIN(
    DISTINCT('Cases'[Customer Created]),
    DISTINCT('Cases'[MonthAndYear])
)

    Desired output:

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution!!

     

     

    Best Regards,
    Shahariar Hafiz

shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
1 year ago

Hi Topjacket  Using crossjoin, you would be able to create all kinds of possible combination. Try below code:

DesiredTable = 
CROSSJOIN(
    DISTINCT('Cases'[Customer Created]),
    DISTINCT('Cases'[MonthAndYear])
)

Desired output:

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution!!

 

 

Best Regards,
Shahariar Hafiz

  • Topjacket's avatar
    Topjacket
    Icon for Helper I rankHelper I
    1 year ago
    shafiz_p
    Well this is just delightful! Thank you very much for your help. I was reading up elsewhere and it was looking like it wasn't going to be straightforward so its great to see a very simple solution.
    Thanks again