Forum Discussion
EZV12
Helper IV
5 years agoDAX formulas requests - please help
Dear all, I urgently need your help to figure out some DAX formulas. Here is the link https://1drv.ms/u/s!AnbNXrfr-X8jdCh4I-viYzEgvpw?e=kGjuRO for a sample file pbix. Here below please a pictu...
selimovd
Most Valuable Professional
5 years agoHey EZV12 ,
the column you want to summarize is in a text format. In order to calculate with that column, you have to change it to a number.
I would strongly recommend to do that already in your data source.
If that's not possible, you can try to convert it with the CONVERT function. But that doesn't make sense in my opinion.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
EZV12
Helper IV
5 years agoHello Denis,
I tried but another 2 windows poped up:
- v-easonf-msft5 years ago
Community Support
Hi, EZV12
Please refer to this related documnent:
https://community.powerbi.com/t5/Desktop/Changing-Data-Type-of-a-Column/m-p/1543656
Best Regards,
Community Support Team _ Eason- EZV125 years ago
Helper IV
Thank, Eason, I will have a look!
Best regards
Rachel