The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Hi, @amitchandak
Measure not work
The measure gives the value of only the hour
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |