Forum Discussion
Helper IIIPowerquery in between date : Google Analytics connector
Hello,
I want to analyse my google Analytics campain between 1.1.2020 and today (dynamicaly)...
I found the way to specify the start date and the end date, but not dynamicaly.
I found this https://community.powerbi.com/t5/Desktop/Calculating-Days-Between-a-Date-and-Today/td-p/389696
but I can't find formula to change dynamicaly the date like this example...
In my case I can't specify any formula
Can you help me ?
Noliverte
hi noliverte
From your two screenshots, they are Calculate columnS, so please click "New Column" as below to specify the formula
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-columns
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns
Regards,
Lin
2 Replies
- amitchandak
Super User
noliverte , first use add the column and then enter formula
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
v-lili6-msftCommunity Support
hi noliverte
From your two screenshots, they are Calculate columnS, so please click "New Column" as below to specify the formula
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-columns
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns
Regards,
Lin
