Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter in formular - difference result in Tableau and Power Bi

Hi,  first of all I would like to say thank to Anonymous guiding me to build  Cohort Analysis in Power Bi.  but to go further, my real data set I need to filter the Delivery Status Chosen(Choose or...
Need Help
Show and Tell
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous 

 

Values in a calculated column are fixed. They are an immutable result for each row in the table. You just need to create a measure.

Measure =
VAR d =
    MIN ( Sheet1[ORDER DATE] )
RETURN
    d - DAY ( d ) + 1
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Moreover, 

in this case, the Order Date is for each month of the each. 

I created the Cohort Analysis to see how many customers comes to business at each month of the year. 

Just want to clarify more!!