Forum Discussion
Topjacket
Helper I
Helper ISummarize 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 ...
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
Super User
Super UserHi 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
TopjacketHelper I
Helper Ishafiz_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