Forum Discussion
Angelvan
7 years agoFrequent Visitor
Scaffold Date in Power Bi
I posted a similar questin before but now I now the solution is to create a scaffolded data set but still don't know how to do it in Power Bi. Can anyone help with the query below: I want to ...
- 7 years ago
Have a look at this
https://community.powerbi.com/t5/Desktop/Calculate-DayNumber-between-Two-Dates/m-p/773693#M372773
There's a DAX solution, a Power Query solution and a pbix to look at.
It's a slightly different case to yours but you should get all the info you need
HotChilli
7 years agoCommunity Champion
Have a look at this
https://community.powerbi.com/t5/Desktop/Calculate-DayNumber-between-Two-Dates/m-p/773693#M372773
There's a DAX solution, a Power Query solution and a pbix to look at.
It's a slightly different case to yours but you should get all the info you need
- Angelvan7 years agoFrequent Visitor
Thanks very much - this worked!