Forum Discussion
Need help with DAX
Hi everyone, I am in a situation. the screen shot below is in excel, i have all the measures except for the ones in the red rectange. I am fighiting to get a way to calcualte this in powerbi. ...
Hi,
Share some dummy data in an Excel file and on another tab, show the expected results with your formulas. I will try to translate those Excel formulas in the DAX language. Share only as much data as is required to get those 3 calculations.
There is no concept of cell merging in visuals. Therefore, the workaround would be to insert quarter and half year columns and show the ro 14 and 15 calcultions under those columns. If you are OK with my approach, then share the download link of the PBI file.
Hi Ashish_Mathur , thanks. I already attached the PBIX file link already. Here it is again
Hi,
PBI file attached. All the growth rates appear in 1 row itself (YoY).
Hope this helps.