Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi
how to define delimter with format group ( ribban ) tp a selected column in query or table ??
the only way that i find is
total_invoice_sales = Format((Fact_InvHeader[table_price]*2),"standard")
for a measure or new column
with this formula i it is not possible to select this measure to a value in chart
or to set sumeris !!
Solved! Go to Solution.
Hi @benfrenkel,
The FORMAT function(DAX) will convert a value to text according to the specified format. So you cannot use it as the value(a number type is needed) in chart or to set summaries for it.
Instead of using Format function in this scenario, I would suggest you use the Formatting options under Modeling tab to format your measures or calculate columns.
Regards
Hi @benfrenkel,
The FORMAT function(DAX) will convert a value to text according to the specified format. So you cannot use it as the value(a number type is needed) in chart or to set summaries for it.
Instead of using Format function in this scenario, I would suggest you use the Formatting options under Modeling tab to format your measures or calculate columns.
Regards
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |