Forum Discussion
christianfcbmx
8 years agoPost Patron
DAX IDEAS PLEASE
Dear Colleagues Im not getting so smart today and I need your help: Im trying the following: I need to create a chart out of my data always getting the last 5 or 4 weeks (Axis Y quantities, axis ...
Ashish_Mathur
8 years agoSuper User
Hi,
I think i can help you with answering the first question. Share some data and show your expected result there.
- christianfcbmx8 years agoPost Patron
Hi Ashish_Mathur... look what I did with the months is what I need with the weeks (I was thinking about an index column) tell me what you think....thanks in advance!
https://www.dropbox.com/s/f99yqz9my1nyjx6/Counting%20weeks%202.pbix?dl=0
- Ashish_Mathur8 years agoSuper User
Hi,
You have to use the CALCULATE, COUNT and DATESBETWEEN functions in a measure. Somehow when i try it, i get a syntax error and cannot figure out why i get that error.