Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Reshape data

Hi there   I got a dataset I need to reshape but I am not sure how to do so, I would like to use DAX to resolve this rather than M code.   I got a computer log on data like this   User     Star...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

     

    You can take a look at below sample:

     

    1. Source table.

    RecordsTime list

     

    2. Calculated column formula to calculate the count.

     

    Count = COUNTAX(FILTER(ALL('SampleFile'),[StartTime]<=[Hour]&&[EndTime]>=[Hour]),[User])+0

     

     

    Resut table

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Im not sure why it doesnt work for me :(

 

Basically I got kida snow flake type of schema...

 

- LogTable (table1)

- Time (table2)

- Structure (link with logtable by Userid)

- Location (link with Structure by Structure id)

 

 

So I need to be able to slice it by structure and location. I guess thats where i went wrong. But even if I slice it y User as per your example it didnt seem to return the right number of rows :(

danrmcallister's avatar
danrmcallister
Resolver II
9 years ago

Anonymous

 

If you could supply some screenshots of your tables that would be helpful to figure out what's happening.  It could be as simple as a data formatting issue!  Hard to say.

 

Dan