Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I was wondering if anyone could help.
I currently have a table like the one shown below where the column 'Metric' contains Days and Revenue.
At the moment, I have a calculated measure called Day Rate which is displayed as a seperate column:
Thank you in advance!
Solved! Go to Solution.
Hi @MissBI_21 ,
I created some data:
You can follow the order of the columns in this table to create:
Here are the steps you can follow:
1. Create calculated table.
SUM_table =
var _summtable=
SUMMARIZE('Table',
[Date],
[Division],
"Metrice","Day Rate",
"Value",
(
SUMX(FILTER(ALL('Table'),'Table'[Metric]="Revenue"&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))),[Value])
/
SUMX(FILTER(ALL('Table'),'Table'[Metric]="Days"&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))),[Value]))/2
)
return
UNION(
'Table',_summtable)
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @MissBI_21 ,
I created some data:
You can follow the order of the columns in this table to create:
Here are the steps you can follow:
1. Create calculated table.
SUM_table =
var _summtable=
SUMMARIZE('Table',
[Date],
[Division],
"Metrice","Day Rate",
"Value",
(
SUMX(FILTER(ALL('Table'),'Table'[Metric]="Revenue"&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))),[Value])
/
SUMX(FILTER(ALL('Table'),'Table'[Metric]="Days"&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))),[Value]))/2
)
return
UNION(
'Table',_summtable)
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you for this.
Although I had to change my data to a table, this did work.
Thank you for this.
Although I had to change my data to a table, this did work.
@MissBI_21 , Not you can not add measure to column.
You need to create a meausre
Or try dynamic segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
THanks for the above but how can I show days and day rate in a matrix?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |