Forum Discussion

ruhor's avatar
ruhor
Frequent Visitor
10 years ago

Parsing Multiple Measures From a String in DAX

I have a DB table that contains water meter information for tiered billing:   meterid name graduated mincharge ranges standardcalculation ------------------------------------------------------...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

You wind up with this:

 

In looking at this, probably not exactly what you are looking for, but some form of this might get you there, will continue to take a look at it, I assume what you want is something like: 9 Sunburg Water True 17.95 C*.0025+17.95 5000 9 Sunburg Water True 17.95 C*.005 7000 9 Sunburg Water True 17.95 C*.0062 999999 ?
ruhor's avatar
ruhor
Frequent Visitor
10 years ago

Yes, looking at your table, I think that would get me to where I aim to go. I am new to the BI analytics field but have a software background. I am not familiar with the tools (ETL, splits/unpivots) required to implement the two solutions but will start looking in to them.

 

I would like to thank both of you for your help.

 

Thanks!