Forum Discussion

EZV12's avatar
EZV12
Icon for Helper IV rankHelper IV
5 years ago

DAX 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...
Need Help
EZV12's avatar
EZV12
Icon for Helper IV rankHelper IV
5 years ago

Dear Denis,

Thank you very much for your feedback and detailed solutions. I created the formulas in my real report under DQ mode, but when I add them in the report, a window poped up like below:

Is it due to the DQ mode?  It works in my sample file entered manually, but it doesn't work in the pbix file under DQ mode. Can you help me with some solutions ?

Thank you.

Rachel 

 

 

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey 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