Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove duplicates in DAX

Hi Guys,   Edit: Proving more informations   I have this two different tables, the fact table (many ids) and my time table (unique id) TABLE 1 FACT  TimeID ID start time finish time 1 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

danextian's avatar
danextian
Icon for Super User rankSuper User
5 years ago

hI Anonymous ,

Does your table indicate which value in Time column comes first for each ID? You may create a formula that returns only the value for Morning but Morning may not alwasy be the first value.