Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create a Calculated Column from Different Tables

Hi,   I have data as in the table below: I need period end dates (month end dates from jan to dec 2018). I was able to create a new table with the required dates. However for my further calculatio...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Could you please explain the logic of the output? Wht the Status required are all new?

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I need to categorise my data in differnt months. I would add a filter for period end date on my dashboard. So if my users want to take a look at the status at the end of october, they would select october and they would have filtered data available just for october. 

For example this is what my dashboard looks like when october month is selected:

 

New Clients30
Lost Clients12
Opening balance20000
Closing Balance65000

 

The data changes to this, when september is selected. An so on.

 

New Clients10
Lost Clients5
Opening balance8000
Closing Balance45000

 

All fields here are calculated fields. How do i categorise my data in power BI? (Can easily do in excel and Tableau)

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous，

     

    Kindly share your pbix. You can upload the file to dropbox and share the link here.

     

    Regards,

    Frank