Forum Discussion
KRD
3 years agoNew Member
How to count two columns against the same value...
Hello, I'm looking for some help in how to count two columns against the same value. The data is regarding visits into and out of an area (for example, a shop, or a ward in a hospital), I have th...
mickey64
Super User
2 years agoStep 0: I use these data.
Step 1: I add a 'Date' column on Power Query Editor.
- Before -
- After -
Step 2: I add a 'Time' column on Power Query Editor.
- Before -
- After -
Step 3: I change the type of 'Time' column.
'Time' column: 'Time' --> 'Decimal Number'
Step 4: I add a 'Hour' column below.
Step 5: I change the type of 'Hour' column.
'Hour' column: 'Decimal Number' --> 'Whole Number'
Step 6: I click 'Close & Apply'.
Step 7: I make a matrix on Power BI Desktop.