Cosine similarity between days of the week

[SHC23]

Hi,

I am looking at temporal patterns of bikes usage and I would like to calculate the cosine of similarity between the days of the week on Power BI.

Can anyone help?

Thank you!

[v-shex-msft]

Hi @SHC23,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@SHC23 , Assume you have Date in you table, you can create date table, with a weekday name etc. they

you can use tailing 7 day measure to get lat week data. Nore date will needed in visual or slcier

  7 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAy))

refer if needed

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510