Roadmap for PowerBI development

See also questions close to this topic

• delete a table form a database using laravel command

  i need to delete a database table using laravel artisan command . not like this command php artisan migrate:rollback --step=5

  i need to create like this route or controller code .

  Route::get('/clear/database', function () {

      Artisan::call('cache:clear');
      return redirect('/');
  

  });

  . i also try public function dd()

  {
      Schema::drop('table_name');
  }
  

  but it not working . gives me error like this SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (SQL: drop table table_name)

  no foreign key for the table . what should i do ?

  thanks in advance!
• How to bring data frame into single column from multiple columns in python

  I have data format in these multiple columns. So I want to bring all 4 columns of data into a single column.

  YEAR Month pcp1 pcp2 pcp3 pcp4              
  1984    1   0   0   0   0
  1984    2   1.2 0   0   0
  1984    3   0   0   0   0
  1984    4   0   0   0   0
  1984    5   0   0   0   0
  1984    6   0   0   0   1.6
  1984    7   3   3   9.2 3.2
  1984    8   6.2 27.1    5.4 0
  1984    9   0   0   0   0
  1984    10  0   0   0   0
  1984    11  0   0   0   0
  1984    12  0   0   0   0
  
• On the time function of database

  When I use Kingbase database in Windows environment, I find that the time function returns the same value in the same transaction. How do I deal with it
• Images with Firebase and Python Flask API

  I am currently developing an API using Firebase from google and Python's Flask libraries. It is a proyect where I am in need of saving images to the DB and then adress them in the API. I would also like to know how to relate the image to an item in the database, say posting an image of Juan, and that is linked with ALL the information from Juan inside the DB. Thanks!
• Need help finding an api or real world data related to read time of people

  I need to create a project for which I require real world data of reading time per page or article. Can anyone help me find data or api in which I can get this data I tried to search for some api but they had information related to books instead of their reading time of a person.
• Using Websocket Channel in React

  I am working on a project where I have to make an api call to a websocket, and display certain information based on that call. As you can see I have used the subscribe portion of the channel in my call. Now I'm not sure what to do if anything with the 2nd two set of bracket. Do I need to include them my call as well, or do they come along with the subscription? And from which of them would I be using the information I need to display? In other words which one is the information I am recieving?

  

  '''

  const ws = new WebSocket("wss://ws-feed.exchange.coinbase.com");
  
    const apiCall = {
        type: "subscribe",
        product_ids: [
            "ETH-USD",
            "BTC-USD"
        ],
        channels: ["level2"]
    };
  
    ws.onopen = (event) => {
      ws.send(JSON.stringify(apiCall));
    };
  
    ws.onmessage = function (event) {
      const json = JSON.parse(event.data);
      console.log(`[message] Data received from server: ${json}`);
      
      
      };
  

  '''
• Can you use a variable to represent a slicer selection in PowerBi?

  I am having a problem displaying a sum value in a gauge visual. My table has many rows with a value in each along with a date. I wrote a measure that calculates the sum of the values filtered by the type of product and whether it was sold during the day or night. The problem is there are many rows of values with the same date so when I put a date drop down slicer on the page, the measure doesn't return a value unless I make the date slicer a "range" which I don't want. I am assuming that the measure doesn't know which value to return when the slicer is in the drop down mode. How can I make this work? Can I use two variables in the DAX code for the measure that provide a date "range" based on the selection in the date drop down that the user chooses?? See below for my current code.

  Table:

      DATE   |   Product Sold   |   Day or Night
  --------------------------------------------------
  4/1/2022            1000               N
  4/1/2022             500               D
  4/1/2022             800               N
  4/1/2022            2000               D
  4/2/2022             900               N
  
  Measure = CALCULATE(
      SUM('Table'[Product Sold]),
      'Table'[Day or Night] IN { "N" })
  

  So the gauge visual won't display a value based on this measure when using a drop down date slicer. It should display 1,800 when the drop down date slicer has a date of 4/1/2022

  The gauge visual WILL display the sum value when using a date range slicer but I can't use that type.

  I hope this makes sense. There has to be a way around it to make it work. I'm at a loss.
• Count occurances in multiple filtered rows

  I need a little help since im new to PowerBI. I have a data set which says what have been eaten in a specific day. At the end there are columns which show if the day before the overall feeling was better (so in this specific day it got worse). I got up to 30 Ingredients and 5 days before. The "1" in e.g. Day2 means its TRUE for condition "2 days before it got worse"

  The data looks like this: Data set example

  Now, I want to retrieve and add up all ingredients, which has been eaten at "Day1", "Day2" and so on, so I can see which food is maybe causing problems because it should appear more often in the days before or at least appear in every case there. How do I achieve this?

  For example I can see then, that on Day2 overy often Ingredient "Apple" appears, so there could be an assumption that Chicken meat is not good for this person.

  I tried to pivot the table, as well as disconnect the "DayX" into another table and make relationship between them, but nothing adds up the things in the way I want it to.
• About my python learning roadmap and i need a few recommendation

  im a begginer python developer and im learned : variables,operators,lists,if else elif,loops,modules,fucntions,classes,inheritance,try except finnaly,file operations (im learning today btw),My course ends after I finish the topic of file operations. What more topics do you think I should learn?
• Roadmap for Quarkus Jakarta EE 9+ (javax.* to jakarta.* namespace change)

  The Spring framework recently announced their roadmap towards integration of Jakarta EE 9+, which includes the namespace change from "javax.*" to "jakarta.*".

  Is there already a Jakarta EE 9+ roadmap for Quarkus?