Measure Branching Techniques

Power BI
1

image
image1920×1020 96.8 KB

Hi,

I am not able to see orders with respective dates, Could someone please help& look inti it? Really appreciated.

Thanks

2

Hi @maximillia76
Please share a working PBX file so one of the members can attempt to help you on this.

3

Hi @jsodhi ,

Thanks for responding, Here is the attached PBX file. I followed the instructor’s steps, Working with a series of dates and orders. I am unable to get data (Not showing orders for respective dates)based on dates.

Getting Started Power BI.pbix (3.2 MB)

4

So, the reason why you are not able to see orders by date is because your date table only had dates for 2015.
however, your Product Demand table has dates from 2018 and 2019.

so when i changed the dates in your date table in power query,

image
image695×62 3.78 KB

Orders by date become visible.

image

Your date table should always have the dates present in your current data. but also, the future dates that you expect to get added in data (if more data is expected to be fetched in the report).

here is the working file for your reference.
Getting Started Power BI.pbix (282.2 KB)

Hope this helps.

Regards,
Japjeet

1 Like
5

Admired @jsodhi ,

Really learned something today, That why knowing you data is very important. Really appricated.

Thanks

1 Like