Power Query Sum of

[hatstand]

Hi All,
I'm getting lost trying to convert a 'Sum of' Cubevalue into a cell reference. I've tried every combination of text but still cannot get it to work. It's so I can drag the formula along underneath a row of dates. Any pointers would be much appreciated.

=CUBEVALUE("ThisWorkbookDataModel","[Test csv Folder Import].[File].&["&$C$1&"]","[Test csv Folder Import].[Group].&["&$C$2&"]","[Test csv Folder Import].[Section].&["&$B21&"]","[Measures].[Sum of 30/03/2020]")

 

[RoryA]

Assuming you're referring to the last section, you'd want:

"[Measures].[Sum of "&TEXT(your_cell,"dd/mm/yyyy")&"]"

 

[hatstand]

Thank you RoryA, much appreciated. Unfortunately it's giving me a #N/A. I've checked the function side of it and it's returning what you have written, am I missing something?

 

[hatstand]

Sorted RoryA. The cell where the date is needed to be in the General format for the formula to work. Once again, thanks for taking the time to help.