datanerd-in-training-blog

[datanerd-in-training-blog]

DAX Operators

These are pretty standard but the “double pipe” is a new trick for me. 

[datanerd-in-training-blog]

DAX function categories

 - This is a great list to get beginners started and should look familiar to any one transitioning to Power BI from excel.  

[datanerd-in-training-blog]

How-To: Create a rolling calendar in Power BI.

1. Create a new blank query. 

2. In the formula bar, generate a starting date by entering a ‘Literal’ in (YYYY,MM,DD) format:

=#date(2019,1,1)

Press enter

3. Click on the “fX” icon to add a new custom step and enter the formula exactly as shown:

= List.Dates (Source, Number.From(DateTime.LocalNow()) - Number.From (Source), #duration(1,0,0,0))

Remember to convert the results to a table and format as a date field. From there you can add helpful calculated columns like year, month, day ect... using the add column tools. 

[datanerd-in-training-blog]

And it begins.