Forum Discussion
Alternative to merging large table - Need null values in a table
Hello, I want to create Table 1 (see below) and eventually join it with Table 2. I want to create table 1 with the following fields: - Dates from 1/1/2019 - 12/31/2019 - Severit...
Anonymous ,
Refer this post:
Thanks,
Tejaswi
jdbuchanan71
Super User
Super UserHello Anonymous
You can use the CROSSJOIN function to generate a table. Something like.
Big Table =
VAR Severities = DATATABLE("Severity",STRING,{{"Severity 1 - Critical"},{"Severity 2 - Major"},{"Severity 3 - Minor"},{"Severity 4 - Trivial"}})
VAR FirstJoin = CROSSJOIN ( Severities, VALUES('Projects'[Project Key]))
RETURN CROSSJOIN (FirstJoin,Dates[date])thank you this worked.