Forum Discussion

GregoryMartin's avatar
GregoryMartin
Frequent Visitor
8 years ago
Solved

Continous X Axis with data (integers) from two different tables

Hello there, me again,   Solved my last problem with continuous X-axis involving dates from two different table with the CALENDARAUTO() functionnality (thanks again to jthomson) but I'm now having ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi GregoryMartin,

     

    Filtering out the blanks could be helpful.

    Result =
FILTER (
    DISTINCT ( UNION ( VALUES ( Table1[ID] ), VALUES ( Table2[ID] ) ) ),
    [ID] <> BLANK ()
)

    Best Regards,

    Dale

GregoryMartin's avatar
GregoryMartin
Frequent Visitor
8 years ago

Before all, thank you both for your quick answers.

 

jthomson : I juste can't found the function you told me about. Power BI only give me the choice between GENERATE and GENERATEALL (as seen on th screenshot). GENERATESERIES is a function given with a plug-in ?

 



v-jiascu-msftI'd already tried to do this way but I couldn't create the relation between this new table and the two others, due tu a non unique values column.

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi GregoryMartin,

 

Filtering out the blanks could be helpful.

Result =
FILTER (
    DISTINCT ( UNION ( VALUES ( Table1[ID] ), VALUES ( Table2[ID] ) ) ),
    [ID] <> BLANK ()
)

Best Regards,

Dale

  • GregoryMartin's avatar
    GregoryMartin
    Frequent Visitor
    8 years ago

    Hi v-jiascu-msft,

     

    Thank you so much ! There was my problem. I was absolutly certain that the DISTINCT funtion was concerning also the 'blank' value and that the table will consider that blank value as unique. Didn't thought of that kind of problem.

     

    Again thank you very much. Problem solved.