Relative Content

Tag Archive for daxpowerbi-desktop

how to create a new column with a calculated relationship?

I want to create a new column with a calculated relationship, but not a set relationship in power bi.
For example, I have two tables
Table A contains a days in 2000 – 2050 using calendar(2000, 2050)
Table B contains the change of Summer Time every year.

how to generate hours like calendar()?

I want to generate a model every two hours and make calculations on each row, just like the calendar().
I have already had calendar() in my model to generate some days. How can I join the days with a set of hours in DAX?
so like: