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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Anonymous

 

Here is a DAX based solution that might be handy to build on.  Just create a new table

 

Summary Table = SUMMARIZE(
    FILTER(
         CROSSJOIN('LogData','Time'),
         [Hour] >= [Start Time] 
         && [Hour] <= [End Time]),
         [Hour],
         "Count",COUNTROWS('LogData')
         )