Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community!
I have a table of receipts with the following data
- date
- Organisation ID
- #Documents
- ID.Product
- Amount
- Time.Coming
My task was to deduce the dynamics of parishes
Dividing the Time.Coming column by Hours and Minutes and combining them with the COMBINEVALUES function, I got the desired result
Now I want to do Measure
VAR _h =
MINX(
ADDCOLUMNS(
'Table.Coming',
"Hour_new",
FORMAT('Table.Coming'[Time.Coming], "HH")),
[Hour_new])
VAR _m =
MINX(
ADDCOLUMNS(
'Table.Coming',
"min",
FORMAT('Table.Coming'[Time.Coming], "NN")),
[min])
Return
COMBINEVALUES(",", _h,_m)
I write this measure but understand that it works incorrectly because it takes minimal minutes
Help me understand how to write a measure correctly
Example file
@DimaMD what is the desired output?
Hi, @smpa01
The desired result is to show the time in this format 9.20
This will allow me to display the dynamics in the chart.
In the example, all calculations are performed through calculated columns
I tried to write a measure but the minutes are displayed incorrectly
@DimaMD , Try like
Format(Min[Time.Coming]), "HH, MM")
Hi, @amitchandak
Measure not work
The measure gives the value of only the hour
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |